Registered aircraft · 1,092

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

N1005MAir Tractor Inc · Olney, TXBuilt 2026 · S/N 802A-1302 N1005VGb Spraying LLC · Bridgeport, NEBuilt 1988 · S/N 402-0694 N10122Aero Spray Inc · Appleton, MNBuilt 2013 · S/N 802A-0495 N1012BMidwest Aerial Applicators LLC · Whittington, ILBuilt 1989 · S/N 402-0712 N1013NVal Air 2 LLC · White River, SDS/N 401-0722 N1017XAaa Aviation LLC · Donalsonville, GABuilt 1989 · S/N 402-0734 N10189Whalen Mark P · Millington, MDBuilt 1989 · S/N 402A-0738 N103LALove Aero LLC · Leland, MSBuilt 2001 · S/N 402A-1133 N1041WRiverside Air LLC · Shelby, MSBuilt 2020 · S/N 802A-0858 N106LAVisser Ag Inc · Rigby, IDBuilt 2001 · S/N 802A-0106 N107MLMike Ogan Farms · Pierre, SDBuilt 2012 · S/N 402B-1250 N10TFBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 602-1217 N10TPAeronautical Technologies Inc · Clovis, NMBuilt 2006 · S/N 802-0246 N1101PJerry Price & Sons Inc · Joiner, ARBuilt 2024 · S/N 802A-1101 N110BHBighorn Flying Co LLC · Wood River, NEBuilt 2001 · S/N 402A-1135 N1122RRegistered aircraftBuilt 2019 · S/N 802A-0794 N112FAFast Ag Air LLC · Watertown, SDBuilt 2025 · S/N 802A-1199 N114EPSilver Sky Ag Aviation LLC · Dumas, TXBuilt 1997 · S/N 602-0465 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 N116KPAtchley Joshua K DBA · Portageville, MOBuilt 2016 · S/N 602-1282 N116THMile High Aviation Inc · Yuma, COBuilt 2025 · S/N 602-1388 N11703Gsd Aerial LLC · O Neill, NEBuilt 2022 · S/N 802A-0949 N118AJCat Agri Aviation Inc · Walnut Ridge, ARBuilt 2009 · S/N 802A-0343 N119JWWestern Pilot Service Inc · League City, TXBuilt 2010 · S/N 802A-0383 N119KPBig Windy Aviation Inc · Watson, ARBuilt 2019 · S/N 602-1305 N120KPPrairie Ag Service LLC · Des Arc, ARBuilt 2010 · S/N 602-1185 N121AAAg Air Inc · Matthews, MOBuilt 2020 · S/N 602-1310 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 N126LAMurdoch Aerial Spraying LLC · Nehawka, NEBuilt 2015 · S/N 602-1261 N127JWScott Cattle Company LLC · Burlington, COBuilt 2014 · S/N 802A-0553 N128CMWesterlin Harrington Flying Service Inc · Holdrege, NEBuilt 2020 · S/N 602-1309 N1290DSky Tech Inc · Dorchester, NEBuilt 2020 · S/N 602-1308 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 N132JWLowry Flying Service Inc · Grinnell, IABuilt 2008 · S/N 602-1156 N1375FBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 402B-1375 N142BMAll In Flying Co · Wilmington, DEBuilt 2006 · S/N 602-1142 N145LADakota Air Spray LLC · Huron, SDBuilt 2006 · S/N 602-1145 N147CAAkbj LLC · Lewes, DEBuilt 2023 · S/N 802-1008 N1500EVaughans Aircraft Leasing LLC · Claremore, OKS/N 402-0820 N15054Air-Ag Inc · Tarboro, NCBuilt 1991 · S/N 402A-0823 N15074Wells Flying Services LLC · Holdrege, NEBuilt 1991 · S/N 402A-0825 N1518ZMoss Jimmy David DBA · Tillar, ARBuilt 1991 · S/N 402-0837 N151LADownstown Airport Inc · Vineland, NJBuilt 2007 · S/N 602-1152

Back to AD 2002-19-10