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.

N20GDCoffey James R · Evergreen, COBuilt 1957 · S/N D-5116 N20GGHofer Danny C · Huron, SDBuilt 1978 · S/N 28-7916032 N20HBMontana Sky Aircraft LLC · Kalispell, MTS/N 18262945 N20HLCs&P Rocky Mountain Inc · Cypress, TXS/N 21061877 N20HMMullett Peter C · Carbondale, COBuilt 1975 · S/N E-750 N20HTRed Arrow Aviation LLC · Santa Teresa, NMBuilt 1969 · S/N 17258306 N20JMWaeltz Mark A · Lantana, FLBuilt 1967 · S/N 28-4393 N20JSOyaski Michael F · Ebensburg, PABuilt 1975 · S/N 18263751 N20JWRocky Mountain Triangle LLC · Castle Rock, COBuilt 1962 · S/N TC-258 N20JXWorld Wide Air & Sea Inc · Wilton, NHBuilt 1990 · S/N 24-3204 N20LGYerena Mario Cesar Gutierrez · Bethel Island, CABuilt 1968 · S/N 28R-30491 N20LLFlying 20 Club Inc · Springfield, ILBuilt 1978 · S/N 28-7990119 N20LXLockheed Martin Corporation · Palmdale, CABuilt 1975 · S/N 31-7552121 N20MCOpie Aviation Services LLC · Nashville, NCBuilt 1979 · S/N 25-0067 N20MUOracle Aviation LLC · Omaha, NEBuilt 1978 · S/N 17271496 N20NGTas Aviation Of Defiance Inc · Defiance, OHBuilt 1971 · S/N 310Q0276 N20PGSteiner Gregory L · Fort Lauderdale, FLBuilt 1966 · S/N 28-22276 N20PVPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4496649 N20PWWingnuts Aviation Inc · Franklin, INBuilt 1979 · S/N 24-0900 N20QCHenderson Stephen L · Carthage, NCBuilt 1977 · S/N 28-7890227 N20RDickerson Stephen R · Frisco, TXBuilt 1960 · S/N 24-1684 N20RHStoltzfus John F Jr · Strasburg, PAS/N 172-68331 N20RLRose Timothy A · Hickory, MSBuilt 1972 · S/N D-9411 N20RNOlive Aviation LLC · Anchorage, AKBuilt 1977 · S/N 28R-7703125 N20RSStendal Russell M · Hollywood, FLBuilt 1970 · S/N 18501826 N20RTTyson Richard E · Barton, FLBuilt 1966 · S/N 3309 N20SALc Air Leasing LLC · Treasure Island, FLBuilt 1976 · S/N 28-7690337 N20TACopperstone Fc LLC · Lancaster, PABuilt 2010 · S/N 2843677 N20TPFrascino Anthony · Johns Creek, GABuilt 1978 · S/N 34-7870306 N20TUClark Steven · Dade City, FLBuilt 1963 · S/N 159 N20TYSuziki Shoji · San Jose, CABuilt 1962 · S/N TC-254 N20UKN Registration Service LLC Trustee · Sanford, NCBuilt 1976 · S/N 22-1380 N20VKEvans Jeffrey L · Mansfield, LABuilt 1977 · S/N 310R0978 N20VMHaney Kieron J · Irrigon, ORBuilt 1965 · S/N 918 N20VRJefferies Wayne · Durango, COBuilt 1997 · S/N 25-2016 N20WFLofton Christopher L · Harlingen, TXBuilt 1976 · S/N 310R0684 N20WGBingham James H · Dillingham, AKS/N 33734 N20WJDiversified Air Services LLC · Edmond, OKBuilt 1993 · S/N 3448027 N20WMMcdonald John P · Kennewick, WAFirst renewal noticeBuilt 1973 · S/N 17261658 N20XKBuildings Evergreen LLC · Bismarck, NDBuilt 1997 · S/N 25-2000 N20YBBurdick Rich · Montrose, COFirst renewal noticeBuilt 1964 · S/N 2708 N21000Yunger John C · Newton, WIBuilt 1972 · S/N 18261346 N21001Global Acquisitions Ltd · Davenport, IAS/N 18261347 N21004M & J Aviation LLC · Clarkston, MIBuilt 1972 · S/N 18261349 N21006Lerma Gilbert L Sr · Salome, AZBuilt 1972 · S/N 18261351 N21009Law Jonathan · Davis, CABuilt 1972 · S/N 18261354 N2100AAniakudo Obiesili · Northville, MIS/N 32R-7987002 N2100EKovach David A Md · Greenwood, INBuilt 1971 · S/N E-290 N2100FDurocher David T · Fernley, NVBuilt 1965 · S/N U206-0301 N2100GTpa Skylane LLC · Asheville, NCBuilt 1958 · S/N 51400

Back to AD 98-21-21 R1