Registered aircraft · 81,733

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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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:81-18-04-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
  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:81-18-04-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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.

N531BPCedar Ridge Aviation LLC · Knox City, TXBuilt 2004 · S/N 1379 N531EREmbry-Riddle Aeronautical University Inc · Prescott, AZBuilt 2023 · S/N 172S13069 N531FSRegistration Pending · Albuquerque, NMRegistration pendingBuilt 1998 · S/N 21908 N531MGN422pj LLC · Missoula, MTBuilt 1999 · S/N 2843260 N531MWLichatz Nick John III · Wesley Chapel, FLBuilt 2017 · S/N 74051 N531NABlue Skies Leasing Inc · Port Orange, FLBuilt 1977 · S/N 28-7790414 N531NDN531nd LLC · Sammamish, WABuilt 2011 · S/N 172S11101 N531PCWaldorff Jimmy M Jr · Altha, FLBuilt 1981 · S/N 17274698 N531PKJcd LLC · Lewes, DEBuilt 2008 · S/N 82205 N531PWLathrop Patrick W · Kent, WABuilt 1972 · S/N 531 N531TGBurns Peter J · North River, NYBuilt 1974 · S/N 1082-75 N531VMcmillan Mark Gilbert · Oak Harbor, WABuilt 1960 · S/N 56685 N5320Barnett Mike · Jacksonville, FLBuilt 1961 · S/N TD-452 N53201Dickinson James J · Renton, WAFirst renewal noticeBuilt 1981 · S/N 17274701 N53202Montana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 2010 · S/N 53 N5320GStroup David J · Alliance, OHBuilt 1953 · S/N 18-2326 N5320HMiller Lorin D · Colo, IAS/N 16-125 N5320YRawareo LLC · Warsaw, MOBuilt 1963 · S/N 27-2397 N5320ZLand Cecil J · Goshen, KYBuilt 1961 · S/N 22-9024 N5321AJust Plane Stuff Inc · Jackson, MSBuilt 2003 · S/N 172S9308 N5321HNurge Richard J · Gilroy, CAS/N 16-126 N5321LBartel Jonathan L · Fresno, CABuilt 1968 · S/N 28-4624 N5321WYoder Michael D · Dundee, OHS/N 28-377 N5321YSchaeffer Zachary M · Maplewood, MNS/N 0-297 N5321ZAyers Mark T · Whitney, TXBuilt 1961 · S/N 22-9025 N53223Ancherani Robert M · Scranton, PABuilt 1981 · S/N 17274703 N5322JResearch Insight LLC · Laguna Beach, CABuilt 2001 · S/N 2843441 N5322PSky Peak Aviation LLC · Los Angeles, CABuilt 2003 · S/N 172S9312 N5322RFreetown Partners LLC · Newark, DEBuilt 1974 · S/N 17263521 N5322WGoecker Craig W · Clarinda, IABuilt 1962 · S/N 28-378 N5322XRodriguez Robert H · Alpine, CABuilt 2001 · S/N 2843483 N5322YKeil Carl · Granbury, TXBuilt 1963 · S/N 18-8048 N5322ZHall Rodney R · Portsmouth, VABuilt 1961 · S/N 22-9026 N53236Principles Of Flight Training LLC · Lees Summit, MOBuilt 1981 · S/N 17274709 N53237Jet Air Inc · Iowa City, IABuilt 2003 · S/N 172S9314 N5323EMaierhoffer Henry F · Sylvania, GAS/N 17271837 N5323FSilmi Amjad · Oakland, CABuilt 1976 · S/N 28-7790087 N5323HCook James N · Mission Viejo, CABuilt 1975 · S/N 17265403 N5323SGrig Aero LLC · Tulsa, OKBuilt 1980 · S/N R18201546 N5323WBibb Benjamin W · Efland, NCS/N 28-380 N5323XGlobal Aviation Corp · Farmingdale, NYBuilt 2013 · S/N 2842392 N5324GFloris Flight Services LLC · Midland, TXBuilt 2003 · S/N 172S9315 N5324LJohnson Jack D · Fresno, CABuilt 1968 · S/N 28-4627 N5324PN5324p LLC · Naples, FLBuilt 2001 · S/N 2843452 N5324TBlake Rodney · Trophy Club, TXBuilt 1972 · S/N 28-7225400 N53250Smith Leon Reese · Soldotna, AKBuilt 1943 · S/N 240 N5325HAdams William Carter · Macon, GAS/N 16-130 N5325NSchindler Lawrence A · Chino Valley, AZBuilt 2003 · S/N 172S9317 N53262Fort Leavenworth Flying Activity · Fort Leavenworth, KSBuilt 1981 · S/N 17274713 N53265Jeppesen Employees Flying Association · Englewood, COBuilt 1981 · S/N 17274714

Back to AD 81-18-04 R2