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.

N2523GDannebrog Air LLC · Grand Island, NEBuilt 1959 · S/N 51823 N2523QLusk T Quizy · Springfield, COBuilt 1966 · S/N 18257723 N2523RBergamaschi Brian A Trustee · Davis, CABuilt 1967 · S/N 18258223 N2523UPro Renovations Savannah Ltd Co · Savannah, GABuilt 1979 · S/N 28-8016030 N2523VExpress Flight LLC · Bloomingdale, GABuilt 1975 · S/N 34-7570143 N2523YLawson Matt E · Gobles, MIBuilt 1962 · S/N 17249823 N2524DSutton Aircraft Salvage LLC · Palmer, AKBuilt 1952 · S/N 20676 N2524KGanz Brian L · Carlsbad, CABuilt 1978 · S/N 18052969 N2524LGraham Jacob W · Rose Hill, KSBuilt 1966 · S/N 17255724 N2524QBellamy Flying LLC · Elwood, NEBuilt 1966 · S/N 18257724 N2524UAir Warriors LLC · Opelika, ALBuilt 1979 · S/N 28-8016031 N2524VJohnson Randon · Snowflake, AZBuilt 1948 · S/N 18028 N2524YPaul Danny W · Locust Grove, GABuilt 1962 · S/N 17249824 N2525Davis Bill M · Kent, WABuilt 1976 · S/N 28-7790180 N2525CWeishaar Pilot · Odessa, WABuilt 1954 · S/N 26169 N2525DStephan Andrew Ryan · Eagle River, AKBuilt 1952 · S/N 20677 N2525GWoods Dana · Mountain View, ARBuilt 1959 · S/N 51825 N2525QHohman Cory A · Lometa, TXBuilt 1966 · S/N 18257725 N2525RBrandt Jimmie L · Elbert, COBuilt 1967 · S/N 18258225 N2525XTolbert Mark A · Canandaigua, NYBuilt 1977 · S/N 21061803 N2525YWilde Stephen · Elverta, CABuilt 1985 · S/N 28-8516075 N2525ZMansfield Scott J · Wasilla, AKBuilt 1962 · S/N 185-0525 N2526DThomas Joel Matthew · Bethel, AKBuilt 1956 · S/N 20678 N2526QRegistration Pending · Lithonia, GARegistration pendingBuilt 1977 · S/N 34-7770189 N2526RTalkeetna Denali View Lodge LLC · Talkeetna, AKBuilt 1967 · S/N 18258226 N2526SPlane Nutz LLC · Sugar City, IDBuilt 1979 · S/N R18201347 N2526XBolin David A · Kenmore, WAS/N P206-0026 N2526YJahnke Ryan M · Grafton, WIBuilt 1962 · S/N 17249826 N2527CDuffy Lawrence R Jr · Vinemont, ALBuilt 1954 · S/N 26171 N2527DSidders Michael E · Big Lake, AKS/N 20679 N2527GRafter H Livestock · Rawlins, WYBuilt 1959 · S/N 51827 N2527LWooten Craig J · Campobello, SCS/N 17255727 N2527QTwenty Inc · Wilmington, DES/N 18257727 N2527UDeljanovan Trucking LLC · Roaring Branch, PABuilt 1979 · S/N 28-8090050 N2527VWright James C · Sulphur Springs, TXBuilt 1948 · S/N 18031 N2527YSuazo Tito L · Glendale, AZBuilt 1962 · S/N 17249827 N2528LWings Of Faith · Stevensville, MTBuilt 1966 · S/N 17255728 N2528RHutchens Robert L II · Mocksville, NCBuilt 1967 · S/N 18258228 N2528UPensacola Navy Flying Club · Pensacola, FLBuilt 1979 · S/N 28-8090051 N2528XButcher Collin E · Freeport, TXBuilt 1964 · S/N P206-0028 N2528YHock Adam · Ankeny, IABuilt 1962 · S/N 17249828 N2529UCampbell Alto L III · Pike Road, ALBuilt 1963 · S/N 17250129 N252AStallings Aircraft Propeller LLC · Wynne, ARS/N 25-1011 N252AALadson Timothy L · Savannah, GABuilt 1961 · S/N CD-330 N252ACStewart Brent E · Oro Valley, AZS/N 25-1159 N252ADNeret Michael George · Sugar Land, TXBuilt 1987 · S/N 25-1109 N252AHStordahl Ronald A · Thief River Falls, MNS/N 25-1000 N252AJPhainopepla LLC · Tucson, AZS/N 25-1115 N252ANVan Waardhuizen Jonathon B · Sarasota, FLS/N 25-1118 N252APBraun Eric Trustee · Anthem, AZS/N 25-1119

Back to AD 98-21-21 R1