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.

N1808ZFlanagan Enterprises (Nevada) Inc · Zephyr Cove, NVNon-citizen corporation, flight hours not reportedBuilt 1962 · S/N 205-0008 N1809AHi-Ho Air LLC · Wilmington, DEBuilt 1981 · S/N E-1872 N1809HAviation Consulting Expertise LLC · Fairfax Station, VAS/N 28-7790314 N1809LThomson Brian Trustee · Saugus, CABuilt 1976 · S/N CE-639 N1809TAudilet Brett Y · Liberty, TXBuilt 1971 · S/N 28-7125162 N1809XMilburn Thomas D Trustee · Lompoc, CABuilt 1964 · S/N 18255909 N1809ZCleared For Departure LLC · Kennewick, WABuilt 1962 · S/N 205-0009 N180AHigginbottom Nathan · Cave City, ARBuilt 1954 · S/N 31090 N180AAButler Tracey D · Buckley, WABuilt 1973 · S/N 18052399 N180ABFoster Bradley J · Wichita, KSBuilt 1953 · S/N 30210 N180ACDupont Cody C · Allison, TXBuilt 1969 · S/N 28-5653 N180AFRegistered aircraftBuilt 1957 · S/N 32809 N180AGAg Leasing LLC · Wilmington, DES/N 18052187 N180AHSwiss Arctic Flyers Inc · Lewes, DEBuilt 1981 · S/N 18053192 N180AKBecker Kurt G · Dexter, NMBuilt 1955 · S/N 31349 N180ANJones Marvin B · Farmerville, LABuilt 1957 · S/N 50008 N180APAir Plains Services Corp · Wellington, KSBuilt 1965 · S/N 18051472 N180AQTracy Michael R · Santee, CABuilt 1967 · S/N 18051848 N180AXNoyes Abigail · North Pole, AKBuilt 1969 · S/N 18051910 N180AYPerkins Paul Fortaine · Anchorage, AKS/N 50052 N180AZMohr Elizabeth G · Brandon, MSBuilt 1974 · S/N 18052433 N180BADavis Robert D · Camas, WAS/N 18052419 N180BBSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1979 · S/N 18053103 N180BDSanderson Bryan D · Emmett, IDBuilt 1954 · S/N 30848 N180BFComunale Anthony S · Roxbury, CTBuilt 1973 · S/N 18052402 N180BGCmw Aircraft LLC · Hailey, IDS/N 31372 N180BHMorris Christopher H · Valparaiso, INS/N 18052132 N180BKKrissman Ryan · Gallup, NMBuilt 1970 · S/N 18052120 N180BRDainas Barry · Port Orange, FLBuilt 1955 · S/N 31386 N180BSSerie Dennis P · Chugiak, AKBuilt 1959 · S/N 624 N180BTAerobug LLC · League City, TXBuilt 1967 · S/N 18051815 N180BVGarcia Karin M · Richland, WAS/N 28-4161 N180CBrown Hector M · Glenwood Springs, COBuilt 1956 · S/N 32312 N180CBSmith Dennis A Trustee · Salem, ORBuilt 1955 · S/N 31489 N180CCMorrison Gerald L · Kansas City, MOBuilt 1974 · S/N 28-7505048 N180CDHicks P David · Heber City, UTS/N 18052310 N180CETailwinds Ranch LLC · Orlando, FLBuilt 1976 · S/N 18052669 N180CJWipaire Inc · South Saint Paul, MNBuilt 1975 · S/N 18052539 N180CQKehoe William R · Port Clinton, OHBuilt 1973 · S/N 28-7305306 N180CRSnow Robert J · La Mesa, CAS/N 30627 N180CTPerformance Paradise LLC · Eagle Harbor, MIBuilt 1959 · S/N 50632 N180CVN Registration Service LLC Trustee · Sanford, NCBuilt 1968 · S/N 28R30693 N180CYYoung Ideas LLC · Post Falls, IDS/N 50460 N180DProuty Edgar C Jr · Sebec, MES/N 31168 N180DAAalgaard Raymond F · Hollister, CABuilt 1956 · S/N 32476 N180DCWilson Lewis G Jr · Rock Hill, SCBuilt 1965 · S/N 18051605 N180DFSale Reported · Anchorage, AKSale reportedS/N 31892 N180DGHodnett Stephen T · Canadian, TXBuilt 1955 · S/N 31280 N180DHMarden Aero Services LLC · Erwinna, PABuilt 1975 · S/N 18052615 N180DJHuang Sophie M · Newcastle, WABuilt 1954 · S/N 31154

Back to AD 98-21-21 R1