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.

N300PM300pm LLC · Bloomington, INBuilt 1978 · S/N 310R1382 N300PSRight Coast Ventures LLC · Royse City, TXBuilt 1968 · S/N 17257501 N300QRPdq Flight Inc · Garden City, NYBuilt 1979 · S/N 17273539 N300REMoreau Leo B · Wasilla, AKBuilt 1965 · S/N 30-841 N300RJTcj Kqc LLC · Robstown, TXBuilt 1976 · S/N 32R-7680286 N300RMHiscall Enterprises Inc · Dickson, TNBuilt 1970 · S/N 32-7140003 N300RRRegan Richard Michael · Leesburg, VAS/N CE-177 N300RSLane Tyrone · El Dorado Hills, CABuilt 1977 · S/N CE-689 N300RTChoux Aviation LLC · Cypress, CABuilt 1983 · S/N E-2074 N300SAWhalen Sean B · Naples, FLS/N CE-545 N300SKKayrouz Sebastien V · Richardson, TXBuilt 1978 · S/N R18200663 N300SZSpp Aviation LLC · Minot, NDBuilt 1981 · S/N 24-1108 N300TDContinental Aerospace Technologies Inc · Mobile, ALBuilt 1978 · S/N 18266128 N300THPacific Flight Academy LLC · Honolulu, HIBuilt 1972 · S/N TH-266 N300TTDg Aero LLC · Little Rock, ARBuilt 1980 · S/N CE-906 N300UBoard Of Regents Of The Univeristy Of Oklahoma · Norman, OKBuilt 2025 · S/N 28020226 N300UMMurray Air LLC · Patoka, ILBuilt 1982 · S/N 32R-8213043 N300VMDavis Laramie · Canyon, TXBuilt 1976 · S/N 32R-7780120 N300WAThunderbolt Air LLC · Granbury, TXBuilt 1968 · S/N 31-294 N300WEK & S Aero LLC · West Chester, PABuilt 1979 · S/N 32R-7985007 N300WLRosen Robert D · Lewisville, NCBuilt 1977 · S/N 32R-7780474 N300WYChupka William J · Riverton, WYBuilt 1965 · S/N 28-21280 N300YBGospel Ministries International Inc · Collegedale, TNBuilt 1986 · S/N 24-3010 N30100Jetstream Cowboys LLC · Bloomfield Hills, MIBuilt 1978 · S/N 34-7870463 N30101Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995069 N3010ELenzen Richard D Dr · Antioch, ILBuilt 1978 · S/N 28-7916167 N3010KGoodwin David · Edinburg, NYBuilt 1978 · S/N 28-7911086 N3010LJones Johnny R · Thermopolis, WYBuilt 1965 · S/N 310J0010 N3010TBb Air Corp · Tulsa, OKBuilt 1979 · S/N 32-7940060 N3010UWestfly LLC · Kalispell, MTBuilt 1963 · S/N 17250610 N3010WSunwest Aviation Inc · Santa Ynez, CABuilt 1995 · S/N 28-43016 N3010YPn4 Aviation Holdings LLC · Bishop, CABuilt 1979 · S/N 28R-7931151 N30114International Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916076 N30117D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7916077 N3011ACooper Remel R Jr Trustee · Green Cove Springs, FLBuilt 1953 · S/N 25655 N3011FGordon Air Services Inc · Miami, FLBuilt 1974 · S/N 17263447 N3011KBravo Farm LLC · Dover, DEBuilt 1978 · S/N 32-7940023 N3011NLange Jonathan R · La Mesa, CAS/N 28-7911098 N3011TBranson West Development Inc · Paso Robles, CABuilt 1964 · S/N 320C0011 N3011WHall Larry C · Decatur, ALBuilt 1996 · S/N 28-43065 N3011XHanania-Stout Motorcars LLC · Chattanooga, TNBuilt 1979 · S/N 32-7940093 N3011YStrategic Sourcing Solutions Inc · Topeka, KSBuilt 1962 · S/N 18254011 N3011ZBoe Arvid J · Langdon, NDBuilt 1979 · S/N 28-7916393 N30126Pilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N 28-7990084 N3012ABottoms Engineering & Service Inc · Frankfort, KYBuilt 1978 · S/N 28-7990112 N3012BThrowbacks LLC · Pueblo, COBuilt 1978 · S/N 28-7911016 N3012CHealy David Paul · Arlington, TXS/N D-5677 N3012DArias Herman R · Waco, GAS/N 28-7916154 N3012EDamschroder Rex A · Fremont, OHBuilt 1978 · S/N 17271402 N3012HBonanza Two USA Inc Trustee · Wilmington, DEBuilt 1987 · S/N CE-1109

Back to AD 98-21-21 R1