Registered aircraft · 3,127

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

N146SLDodson International Parts Inc · Rantoul, KSS/N 1091 N146WMWatermakers Air Inc · Fort Lauderdale, FLBuilt 2000 · S/N 208B-0813 N148SAZuni LLC · Kirkland, WAS/N 409 N148SKBering Air Inc · Nome, AKBuilt 1995 · S/N UE-148 N149CCCianbro Corp · Baltimore, MDS/N FA-145 N149QDQuest Diagnostics Clinical Laboratories Inc · Reading, PABuilt 1996 · S/N 149 N149SFAlpine Aviation Inc · Provo, UTBuilt 1991 · S/N UC-149 N14GVScott T LLC · Portland, ORS/N 4697092 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 N150ACJohnson Airspray Inc · Argyle, MNBuilt 1991 · S/N T34-150 N150GWRocinante Air LLC · Cincinnati, OHBuilt 1998 · S/N LJ-1531 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 N151CAAcc Integrated Services Inc · Milwaukee, WIBuilt 1984 · S/N SH3653 N151CLAircraft Structures International Corp · Enid, OKBuilt 1988 · S/N 208B0083 N151LADownstown Airport Inc · Vineland, NJBuilt 2007 · S/N 602-1152 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 N152ALN152al LLC · Tulsa, OKBuilt 2004 · S/N 4697182 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 N1539XRba LLC · Kimberly, IDBuilt 1992 · S/N 502A-0166 N153GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-153 N153PBCarojake LLC · Spartanburg, SCBuilt 1996 · S/N 153 N153SLSouthwest Aviation Specialties LLC · Tulsa, OKBuilt 2002 · S/N 1054 N1540SArthur Aviation LLC · Arthur, NDBuilt 1992 · S/N 502-0171 N1544VGuardian Flight LLC · Lewisville, TXBuilt 1994 · S/N LJ-1366 N1546HAero Spray Inc DBA · Appleton, MNBuilt 1992 · S/N 802A-0003 N1547UR & D Leasing Inc · Lemoore, CABuilt 1992 · S/N 502A-0183 N154CAFedair Inc · Indianapolis, INBuilt 1980 · S/N 31T-8020085 N154CLAircraft Structures International Corp · Enid, OKBuilt 1990 · S/N 208B0212 N154GLAlpine Aviation Inc · Provo, UTBuilt 1995 · S/N UE-154 N1552DDodson International Parts Inc · Rantoul, KSBuilt 1989 · S/N LJ-1204 N1552GEast Atlantic Aviation LLC · Edenton, NCBuilt 1989 · S/N LJ-1206 N1553GMccloy Mark · Tatum, NMBuilt 1989 · S/N LJ-1214 N1556WPrecissi Flying Service Inc · Lodi, CAFirst renewal noticeBuilt 1992 · S/N 502-0185 N15570Shearer Sprayers Inc · The Dalles, ORBuilt 1992 · S/N 402-0884 N15588Slikker Flying Service Inc · Buttonwillow, CABuilt 1992 · S/N 502A-0175

Back to AD 2016-05-13