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.

N200KDQuantum Aero Services LLC · Wilmington, DEBuilt 1958 · S/N TD-176 N200KRDusek Ryan · Cypress, TXBuilt 1976 · S/N 28R-7635176 N200LDFenske Jeffrey D · Gold Hill, ORBuilt 1973 · S/N 21059895 N200LEAeromarine Holdings LLC · Waukesha, WIBuilt 1979 · S/N 310R1842 N200MABas Part Sales LLC · Greeley, COBuilt 1978 · S/N 32R-7887266 N200MDArvelu LLC · Utica, NYBuilt 1973 · S/N 28-7305431 N200NMOrr Leroy A · Tonasket, WABuilt 1960 · S/N 57271 N200NTRichmond Jeremy · Eufaula, OKS/N 28R-35321 N200P10x Aviation Partners LLC · Stuart, FLBuilt 1980 · S/N 31-8052124 N200PWGarris Steven L · Oceanside, CABuilt 1974 · S/N 28-7415182 N200QBluth Marshall S · Great Neck, NYBuilt 1971 · S/N CE-339 N200QRPdq Flight Inc · Garden City, NYS/N U20606092 N200RCRc Aviation LLC · Omaha, NEBuilt 1975 · S/N 21061073 N200RLAlpha Aviation Services LLC · Chelsea, ALBuilt 1969 · S/N 28R-35210 N200RTRiley Nolan C · Lubbock, TXS/N TK-101 N200SBSoaring Hawk Aviation LLC · Dexter, MIBuilt 1978 · S/N 34-7870399 N200SFRes Solutions Inc · Anderson, INBuilt 1978 · S/N 32R-7985034 N200SHHoward Steve · Jefferson City, MOBuilt 1979 · S/N 310R1601 N200SJChanney Aviation Group LLC · Las Vegas, NVBuilt 1981 · S/N 318152054 N200SPN200sp LLC · Erie, COBuilt 1967 · S/N TE-487 N200TEJohnson William L · Fruitland, IDBuilt 1986 · S/N E-2351 N200TLHusnik Brad M · Forest Lake, MNBuilt 1966 · S/N U206-0559 N200UAUrrea Hugo Edmundo Rincon · Houston, TXBuilt 1980 · S/N 21063921 N200UGRaw Logistics LLC · Bethel, NCBuilt 1978 · S/N E-1225 N200USFly More LLC · Chattanooga, TNBuilt 1976 · S/N 28-7690273 N200VMBaker Creek Enterprise · Townsend, GABuilt 1976 · S/N 32R-7780073 N200VVN200vv LLC · Pontiac, MIS/N 18267363 N200WAYoedhana Christian · Pflugerville, TXBuilt 1973 · S/N 28R-7335363 N200WRVaughan Jason B · Sublette, KSBuilt 1978 · S/N 21062478 N200WSSierra Juliet Nm LLC · Santa Teresa, NMBuilt 1974 · S/N 34-7450117 N200YRSloan Cooper · Seattle, WAS/N 28-7615279 N200ZKInternational Air Services Inc Trustee · Carson City, NVBuilt 1966 · S/N 17255678 N20102Wings Over Texas Holdings LLC · Denton, TXBuilt 1972 · S/N 17261010 N20106Atlanta Air Academy LLC · Kennessaw, GABuilt 1972 · S/N 17261014 N2010CLegner Leasing LLC · Las Vegas, NVBuilt 1958 · S/N TD-177 N2010GFox Stephen A · Wasilla, AKBuilt 1958 · S/N 51310 N2010WHogsett Troy J · Willow Springs, MOBuilt 1965 · S/N CD-972 N2010XHutchinson Darrold K Trustee · Hingham, MTBuilt 1965 · S/N 18256110 N2010ZSanchez Michael G · Hesperia, CABuilt 1967 · S/N 28-22409 N2011Harkins Brian Trustee · Vallejo, CABuilt 1978 · S/N 24-0526 N20111Westcott Emily E · Sequim, WABuilt 1972 · S/N 17261019 N20115Alpha Zulu Aviation LLC · San Diego, CABuilt 1972 · S/N 17261021 N2011CTuorila Leo Eric · Anderson, SCBuilt 1958 · S/N TD-178 N2011DGardner Robert J · Reno, NVBuilt 1952 · S/N D-3361 N2011SHeath Stephen · Alpine, TNBuilt 1975 · S/N 21060979 N2011XSalem Ricky L · Burnet, TXBuilt 1965 · S/N 18256111 N20121Fly Maui LLC · Puunene, HIBuilt 1972 · S/N 17261025 N20123Irungu Gitau · Charlotte, NCBuilt 1972 · S/N 17261027 N2012EAirgo Inc · Centralia, ILBuilt 1978 · S/N 17271117 N2012GMchugh Michael J Trustee · Hailey, IDBuilt 1958 · S/N 51312

Back to AD 98-21-21 R1