Registered aircraft · 1,468

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:2001-10-04-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:2001-10-04-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:2001-10-04-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:2001-10-04-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:2001-10-04-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:2001-10-04-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.

N115FARegistration Pending · Roseland, NERegistration pendingBuilt 2025 · S/N 802A-1250 N115LABank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 402B-1152 N116FATesk Aviation LLC · Steele, MOBuilt 2025 · S/N 802A-1231 N116KNClear Skies Aviation LLC · Reserve, MTBuilt 2008 · S/N 402B1202 N11703Gsd Aerial LLC · O Neill, NEBuilt 2022 · S/N 802A-0949 N118AJCat Agri Aviation Inc · Walnut Ridge, ARBuilt 2009 · S/N 802A-0343 N118FAFarm Air Inc · Astoria, ILS/N 502A-3607 N119JWWestern Pilot Service Inc · League City, TXBuilt 2010 · S/N 802A-0383 N1224WMaco Aviation Inc · Dayton, WABuilt 1998 · S/N 502A-0496 N1255ABombero Aviation LLC · Childress, TXBuilt 2025 · S/N 802A-1255 N1255FLipan Creek Flying Service LLC · Eola, TXBuilt 2025 · S/N 802A-1241 N1263FF A I LLC · Marianna, ARBuilt 2026 · S/N 802A-1263 N126HBKansas Farm And Ranch Inc · Seneca, KSBuilt 2014 · S/N 502B-2947 N127JWScott Cattle Company LLC · Burlington, COBuilt 2014 · S/N 802A-0553 N128WWSpears Aerial Crop Care LLC · Mamou, LABuilt 2011 · S/N 502B-2793 N12DAAero Spray Inc DBA · Appleton, MNBuilt 2018 · S/N 802-0777 N130BMBoyds Aviation LLC · Rayville, LABuilt 2006 · S/N 802A-0249 N131LAThompson Flying Service LLC · Charleston, MOBuilt 2024 · S/N 802-1132 N133DEElkinton Dusty Lee · Moundville, MOS/N 502B-2669 N133HFTlc Flying Inc · Colfax, WAS/N 502-0101 N13642Visser Ag Inc · Rigby, IDBuilt 1999 · S/N 502B-0598 N1375FBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 402B-1375 N144KSAas LLC · Ovid, MIBuilt 1986 · S/N 400-0640 N147CAAkbj LLC · Lewes, DEBuilt 2023 · S/N 802-1008 N1500EVaughans Aircraft Leasing LLC · Claremore, OKS/N 402-0820 N1502BAeroag LLC · Portland, INBuilt 1998 · S/N 502B-0476 N1502UCentral Ag Air LLC · Marion, KSBuilt 1991 · S/N 502-0139 N15054Air-Ag Inc · Tarboro, NCBuilt 1991 · S/N 402A-0823 N15074Wells Flying Services LLC · Holdrege, NEBuilt 1991 · S/N 402A-0825 N1507KDakota Air Spray LLC · Huron, SDBuilt 1991 · S/N 502-0142 N15102Moes Crop Dusting Service Inc · Marysville, CABuilt 1991 · S/N 502-0146 N1515GKidd Clifford L · Monahans, TXBuilt 1991 · S/N 502-0152 N15189Tri Rotor Spray & Chemical · Ulysses, KSBuilt 1991 · S/N 502-0155 N1518ZMoss Jimmy David DBA · Tillar, ARBuilt 1991 · S/N 402-0837 N1519ZFlatland Aviation LLC · Indianola, MSBuilt 1991 · S/N 502-0156 N1520QBrekhus Julius P · Kenmare, NDBuilt 1991 · S/N 402-0838 N15210O'Hare R Mike · Clovis, NMBuilt 1991 · S/N 402-0840 N1529ERoth Aerial Spraying LLC · Milford, NEBuilt 1991 · S/N 502-0161 N1529HMiller Aviation Inc · Norton, KSBuilt 1992 · S/N 502A-0158 N1529USnider Scott E DBA · Turner, MTBuilt 1992 · S/N 402-0849 N1529WOlathe Spray Service Inc · Olathe, COBuilt 1992 · S/N 401-0848 N1531GWoodley Aerial Leasing LLC · Walnut, ILBuilt 1992 · S/N 402-0850 N1531SWakefield Aircraft LLC · Cooperstown, NDBuilt 1991 · S/N 802-0002 N1533SMj Aviation Inc · Walnut Ridge, ARBuilt 1991 · S/N 402-0847 N1534DEdge Aviation LLC · Moberly, MOBuilt 1992 · S/N 402A-0855 N1539XRba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0166 N1540SArthur Aviation LLC · Arthur, NDBuilt 1992 · S/N 502-0171 N15439Dietz Timothy E · Wasilla, AKS/N 401-0862 N15449Headwaters Flying Service LLC · Three Forks, MTBuilt 1992 · S/N 401-0868 N1544RRas Aviation LLC · Elyria, OHBuilt 1992 · S/N 401-0864

Back to AD 2001-10-04 R1