Registered aircraft · 85,612

Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.

Query with SQL

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1') ORDER BY n_number

duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
  FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
  WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
  ORDER BY n_number"

Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.

SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:98-21-21-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N2733GSkydive Ky LLC · Cecilia, KYS/N 52033 N2733LHugelman Frank J III · Waynesville, MOBuilt 1967 · S/N 17255933 N2733RPatrick Barb · Farmer City, ILBuilt 1969 · S/N 28R-35275 N2733WMclenaghan Alvin N · Phoenix, AZBuilt 1966 · S/N 3341 N2734CRegistered aircraftS/N 26278 N2734FWard Christopher C · Lufkin, TXBuilt 1965 · S/N 18256834 N2734HGriebel Kyle L · Lafayette, COBuilt 1959 · S/N 52034 N2734Q1175 Bangtail Way LLC · Greycliff, MTBuilt 1967 · S/N 18257934 N2734URegistered aircraftBuilt 1963 · S/N 17250334 N2735CBeach Michael C · Lebanon, ORBuilt 1954 · S/N 26279 N2735DMorpeth Thomas · Fortson, GABuilt 1952 · S/N 25277 N2735GGaunt Galen B · Glennallen, AKBuilt 1959 · S/N 52035 N2735KCook Kyle R · Green Valley, AZBuilt 1979 · S/N 18053049 N2735QRegistration Pending · Hearne, TXRegistration pendingBuilt 1967 · S/N 18257935 N2735TWhite Michael W · Key Largo, FLBuilt 1967 · S/N D-8455 N2735UKnepper Gary E · Canby, ORBuilt 1963 · S/N 17250335 N2736GFor Skies Flying Club Ltd · Martinsville, ILBuilt 1959 · S/N 52036 N2736KP M Logistics LLC · Haskell, OKBuilt 1979 · S/N 18053050 N2736LWilson Steven W · N Richlnd Hls, TXFirst renewal noticeBuilt 1967 · S/N 17255936 N2736QBachich George A · Napa, CABuilt 1967 · S/N 18257936 N2736TM & N Leasing Co · Marietta, GAS/N D-8458 N2736VHatloy Mark A · Drayton, NDBuilt 1947 · S/N D-116 N2736WMcnamara Jeffrey E Trustee · Riverside, CABuilt 1966 · S/N 1036 N2736XMehling Michael R · Fairview, MTBuilt 1965 · S/N 18051536 N2737AKnight Farms Inc · Pasco, WABuilt 1969 · S/N E-175 N2737CBenard Matthew Scott · Lakeville, MABuilt 1954 · S/N 26281 N2737JClair Brent · Loraine, ILBuilt 1979 · S/N 17273643 N2737KFanazick Joseph P · Juneau, AKBuilt 1979 · S/N 18053051 N2737LAviation Trust Co LLC Trustee · Oklahoma City, OKS/N 17255937 N2737XFly-By Aviation Services LLC · Colorado Springs, COBuilt 1965 · S/N 18051537 N2738BSonrise Aviation LLC · Portland, INBuilt 1979 · S/N 310R1828 N2738LDemkiewicz Daniel · Houston, TXBuilt 1967 · S/N 17255938 N2738UVan Der Waal Allan L · Port Angeles, WABuilt 1963 · S/N 17250338 N2738WMead James R · Jonesboro, ARFirst renewal noticeBuilt 1966 · S/N 260 N2739CLge Flying Club Inc · Marietta, GABuilt 1978 · S/N R18200223 N2739GSwanson Gordon · Prescott, AZS/N 52039 N2739LHall Barbara S · Burgettstown, PABuilt 1967 · S/N 17255939 N2739RPerrong Andrew R · Huntingdon Valley, PABuilt 1969 · S/N 28R-35279 N2739TPickering Kevin P · Lakeland, TNBuilt 1967 · S/N D-8457 N2739UN2739u Holding LLC · New Orleans, LABuilt 1963 · S/N 17250339 N2739WKessler Henry L · San Gabriel, CABuilt 1966 · S/N 3344 N2739XSvoboda Realty Inc · Bucyrus, KSFirst renewal noticeBuilt 1965 · S/N 18051539 N2739YEnnis Michael J · Eminence, MOBuilt 1958 · S/N TD-92 N273AAHammerschlag Richard S · Kamiah, IDBuilt 1959 · S/N TD-321 N273BTN273bt Air LLC · Sweetser, INBuilt 1979 · S/N 27-7954112 N273EADavis Jonathon W · Charlotte, NCBuilt 2003 · S/N E3497 N273EBNorth Country Aircraft Holdings LLC · Watertown, NYBuilt 1978 · S/N 17271018 N273FWeimer Heidi L · Knoxville, TNBuilt 1973 · S/N 32-7340138 N273JFParrish Aviation Flight Academy LLC · Southlake, TXS/N 17261732 N273MJSmith Jeffrey W · Shreveport, LABuilt 1979 · S/N 32R-7985065

Back to AD 98-21-21 R1