Skip to content

Registered aircraft · 160

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

N1005VGb Spraying LLC · Bridgeport, NEBuilt 1988 · S/N 402-0694 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 N107MLMike Ogan Farms · Pierre, SDBuilt 2012 · S/N 402B-1250 N110BHBighorn Flying Co LLC · Wood River, NEBuilt 2001 · S/N 402A-1135 N115LABank Of Utah Trustee · Salt Lake City, UTBuilt 2004 · S/N 402B-1152 N116KNClear Skies Aviation LLC · Reserve, MTBuilt 2008 · S/N 402B1202 N1375FBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 402B-1375 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 N1520QBrekhus Julius P · Kenmare, NDBuilt 1991 · S/N 402-0838 N15210O'Hare R Mike · Clovis, NMBuilt 1991 · S/N 402-0840 N1529USnider Scott E DBA · Turner, MTBuilt 1992 · S/N 402-0849 N1531GWoodley Aerial Leasing LLC · Walnut, ILBuilt 1992 · S/N 402-0850 N1533SMj Aviation Inc · Walnut Ridge, ARBuilt 1991 · S/N 402-0847 N1534DEdge Aviation LLC · Moberly, MOBuilt 1992 · S/N 402A-0855 N1544RRas Aviation LLC · Elyria, OHBuilt 1992 · S/N 401-0864 N15570Shearer Sprayers Inc · The Dalles, ORBuilt 1992 · S/N 402-0884 N182PBDodson International Parts Inc · Rantoul, KSS/N 402-0806 N18KDH & W Ag Services Inc · Veribest, TXBuilt 2007 · S/N 402B-1187 N202FHTr Flying Service LLC · Milan, MNBuilt 1992 · S/N 402A-0867 N2047VWilliamsburg Air Service Inc · Kingstree, SCBuilt 2012 · S/N 402B-1253 N2072DPadgett Ag Rotors LLC · Missoula, MTBuilt 2012 · S/N 402B-1268 N213BHBighorn Flying Co LLC · Wood River, NEBuilt 2013 · S/N 402B-1279 N228RGA+ Aviation Services LLC · Garden City, KSBuilt 2009 · S/N 402B-1223 N240DLBlue Earth Flying Service LLC · Blue Earth, MNBuilt 2011 · S/N 402B-1240 N246LAChambers County · Anahuac, TXBuilt 2018 · S/N 402B-1400 N274ATBoardman Air Service LLC · Henderson, NEBuilt 2012 · S/N 402B-1251 N281DLThisius Flying Service Llp · Wells, MNBuilt 2013 · S/N 402B-1281 N281LABoedeker Flying Service East LLC · Childress, TXBuilt 2008 · S/N 402B-1201 N291DLNorthstar Aero Spray Inc · Clara City, MNBuilt 2008 · S/N 402B-1199 N3011SH & H Flying Co · Finley, TNBuilt 2013 · S/N 402B-1276 N3030CWtas LLC · Dyersburg, TNBuilt 2013 · S/N 402B-1283 N3038PAgri-Tech Aviation Inc · Indianola, IABuilt 2013 · S/N 402B-1284 N305LAShores Ag-Air Inc · Corpus Christi, TXBuilt 2014 · S/N 402B-1305 N3070GWilliamsburg Air Service Inc · Kingstree, SCBuilt 2013 · S/N 402B-1303 N321DASherer Robert O · Deadwood, SDBuilt 1991 · S/N 402A-0814 N402CSWoodley Aerial Leasing LLC · Walnut, ILBuilt 1991 · S/N 402A-0816 N402CWThisius Flying Service Llp · Wells, MNBuilt 1998 · S/N 402A-1061 N402DEDeby Ag Leasing Lp · Wakarusa, INBuilt 1991 · S/N 402-0807 N402DGNorth Central Aviation LLC · Valentine, NEBuilt 1999 · S/N 402A-1091 N402FAgriculture Aviation Services LLC · Clarkfield, MNS/N 402A-1125 N402FHAasjng LLC · Holdrege, NES/N 402B-1254 N402GKGress Air LLC · Dunbar, NEBuilt 2004 · S/N 402A-1151 N402JDefenbaugh Matthew J · Biggsville, ILBuilt 2000 · S/N 402A-1117

Back to AD 2008-21-08