OpenAirDocs.org
AD 2017-11-16

Registered aircraft · 833

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

N101LRegistered aircraftBuilt 2023 · S/N 2302N101PKMassey Air Inc · Lucdale, MSBuilt 2016 · S/N 1610N102TP2 T Partnership Ltd · Pecos, TXBuilt 2025 · S/N 2439N104SCLsac Enterprises LLC · Marshalltown, IABuilt 2020 · S/N 2032N106TWTw Leasing LLC · Oxford, CTS/N 1109N10DFGulf States Toyota Inc · Houston, TXS/N 1241N10WAReinbeck Motors Co Inc · Reinbeck, IABuilt 2022 · S/N 2187N110GNWell Adjusted LLC · Naples, FLBuilt 2013 · S/N 1404N110GWGew Aircraft Leasing LLC · Naples, FLBuilt 2013 · S/N 2457N113BDBlack Dog Leasing LLC · Gardnerville, NVBuilt 2024 · S/N 2414N1150HLbj Air LLC · Helena, MTBuilt 2009 · S/N 1150N1150NBlack Falcon Leasing LLC · Gallatin, TNBuilt 2009 · S/N 1156N118NGAvodah Blue LLC · Logan, UTBuilt 2018 · S/N 1833N119UTUnited Therapeutics Corp · Silver Spring, MDBuilt 2015 · S/N 1520N11BYRj Aviation LLC · Ronkonkoma, NYBuilt 2023 · S/N 2295N11NXDiscovery Associates Inc · Midland, TXBuilt 2020 · S/N 2010N11NYKup Air LLC · Mccook, NEBuilt 2016 · S/N 1647N120AHWilmington Trust Co Trustee · Wilmington, DEBuilt 2015 · S/N 1582N120WLN120wl LLC · Del Mar, CABuilt 2024 · S/N 2418N121QIq Worldwide Solutions LLC · Tampa, FLBuilt 2011 · S/N 1299N1220ARivers End Ranch LLC · Lakeview, ORBuilt 2015 · S/N 1568N1227QFly Signature LLC · Newark, DEBuilt 2023 · S/N 2324N122GXFlan Air LLC · Flandreau, SDBuilt 2020 · S/N 2020N122JMBuessli Aviation LLC · Menlo Park, CABuilt 2015 · S/N 1523N122NDAircraft Fidelity Corp Trustee · Dover, DEBuilt 2009 · S/N 1146N123NXHeimdal Aviation LLC · Seattle, WABuilt 2009 · S/N 1123N123SLSo Lucky One LLC · Wilmington, NCBuilt 2015 · S/N 1573N1247EBozeman Technology Incubator Inc · Bozeman, MTBuilt 2017 · S/N 1762N124LTTurner Lyle C Trustee · Santa Barbara, CABuilt 2019 · S/N 1889N124N124 North LLC · Laguna Beach, CAS/N 2072N124PSDuck Pond Aviation II LLC · Livermore, CABuilt 2018 · S/N 1811N124RCutter Flight Management Inc · Albuquerque, NMBuilt 2018 · S/N 1840N125BWBw Air LLC · Houston, TXBuilt 2022 · S/N 2208N126TSLife Flight Network LLC · Aurora, ORBuilt 2009 · S/N 1111N127TWTw Leasing LLC · Oxford, CTBuilt 2015 · S/N 1574N129PKDashiell Corp · Houston, TXBuilt 2015 · S/N 1517N12ARMermerus LLC · Branford, CTBuilt 2015 · S/N 1524N12DHClear Skies LLC · Lafayette, LABuilt 2010 · S/N 1210N12NFNiemann Aviation LLC · Quincy, ILBuilt 2021 · S/N 2128N12NVAir Ally LLC · Chisago City, MNBuilt 2018 · S/N 1801N12XFlying Goose LLC · Kennesaw, GABuilt 2022 · S/N 2204N12XNJdr Aircraft Company LLC · Tampa, FLBuilt 2020 · S/N 2042N131AFManufacturers And Traders Trust Co · Portsmouth, NHBuilt 2021 · S/N 2131N132ASFlight Level Services LLC · Danville, KYS/N 1319N132TPNational Eagle Aviation LLC · Grand Prairie, TXBuilt 2019 · S/N 1859N133PEEpps Air Service LLC · Atlanta, GABuilt 2008 · S/N 1018N134PFPeco Foods Inc · Tuscaloosa, ALBuilt 2014 · S/N 1491N134TWSrb Aviation LLC · Delmar, NYBuilt 2008 · S/N 1013N135PFPeco Foods Inc · Tuscaloosa, ALBuilt 2017 · S/N 1752N138PSEncore Asset Mgmt LLC · Newton, ILBuilt 2016 · S/N 1646
Back to AD 2017-11-16