Registered aircraft · 85,620

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.

N167Palmer Michael · Crystal Lake, ILBuilt 1950 · S/N 19225 N1670CAlaska Freight Services LLC · Fairbanks, AKBuilt 1953 · S/N 30370 N1670FTillamook Pilots Association · Tillamook, ORBuilt 1966 · S/N 17255065 N1670MFirebird Aviation LLC · Tempe, AZBuilt 1975 · S/N 18264410 N1670YMarshall Gregory A · Sauk Rapids, MNBuilt 1962 · S/N 17249370 N1671HBarth Samuel · Fonda, NYS/N 28R-7737008 N1671RDavis Ronald L Jr · Soldotna, AKBuilt 1974 · S/N 18502394 N1671WAviatech Inc · Tamarac, FLBuilt 1972 · S/N D-9382 N1671YDavid Dahl · Shevlin, MNBuilt 1962 · S/N 17249371 N1672EWichita Area Technical College · Wichita, KSBuilt 1978 · S/N 17271089 N1672RBriggs Donald L · Santa Barbara, CABuilt 1978 · S/N R18200507 N1672YSmith David W · Texarkana, TXBuilt 1962 · S/N 17249372 N1673EHusband Thomas W · Bigfork, MTBuilt 1978 · S/N 17271090 N1673FHopkins Ronald J · Salt Lake City, UTFirst renewal noticeBuilt 1966 · S/N 17255068 N1673HTronerud Jason · Maple Grove, MNBuilt 1977 · S/N 32-7740037 N1673JSouthern Colorado Flight Professionals LLC · Pueblo, COBuilt 1967 · S/N 28-24074 N1673MBower Ashley R · Anchorage, AKBuilt 1971 · S/N 18501865 N1673RGregory John F · Emmitsburg, MDBuilt 1978 · S/N R18200508 N1673THarvey Alan G · Dallas, TXBuilt 1981 · S/N E-1895 N1673WOci Ltd · Brunswick, GABuilt 1972 · S/N TH-258 N1673YLentz Gregory · Green Forest, ARBuilt 1962 · S/N 17249373 N1674CFarwest Aviation LLC · Billings, MTBuilt 1953 · S/N 30374 N1674FPlane Nuts Aviation LLC · Livingston, LABuilt 1966 · S/N 17255069 N1674JCaloon John H · Greenfield, MABuilt 1968 · S/N 28-24075 N1674VAbraham Elizabeth J · Browntown, WIBuilt 1974 · S/N 17263709 N1674WLipps Charles J · Fairview, OKBuilt 1972 · S/N CD-1298 N1675DRatcliff Whitcomb T · Carnation, WABuilt 1952 · S/N 20317 N1675HIcarus Flying Academy LLC · Farmingdale, NYBuilt 1977 · S/N 28-7716040 N1675JTevis Aviation Inc · Emporia, KSBuilt 1967 · S/N 28-24076 N1675MWenk Peter J · Ocala, FLBuilt 1971 · S/N 18501867 N1675WHarper Jerad Vincent · Windsor, CAS/N CE-398 N1675XNo Runways LLC · Iraan, TXBuilt 1975 · S/N 21060710 N1676DJohnston Brent A · Galena, OHBuilt 1952 · S/N 20318 N1676FBrunson Tim R · Gilmer, TXS/N 17255071 N1676HClass Bee Inc · Pensacola, FLS/N 28-7716041 N1676RBlue Side Up LLC · Elbert, COBuilt 1978 · S/N R18200510 N1676UDigicam Co · Henderson, NVBuilt 1982 · S/N 21064724 N1676WTrask Barrett Lee III · Matthews, NCBuilt 1972 · S/N CD-1299 N1676XSkydancer Le LLC · Wilmington, DEBuilt 1975 · S/N 21060711 N1676YGray Bryan · Colorado City, TXBuilt 1962 · S/N 17249376 N1677CDavis Aero LLC · Incline Village, NVBuilt 1953 · S/N 30377 N1677JCross X Country LLC · Great Falls, VABuilt 1968 · S/N 28-24078 N1677RYarger Denim B · Laurel, MTBuilt 1974 · S/N 185-02400 N1677WLagrow II LLC · Coloma, MIBuilt 1973 · S/N CE-419 N1678FHorne William D II · Oxford, MSBuilt 1966 · S/N 17255073 N1678HBrown Gregory B · New London, CTBuilt 1977 · S/N 28-7790330 N1678JCloudhoppers Inc · Effingham, ILBuilt 1967 · S/N 28-24079 N1678RPureflight Aviation Training LLC · Newberg, ORBuilt 1974 · S/N 18502401 N1678XFly Guys LLC · Arcata, CABuilt 1975 · S/N 21060713 N1678ZLongmire Dale · Senoia, GABuilt 1962 · S/N 1850470

Back to AD 98-21-21 R1