Registered aircraft · 3,126

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.

N4556UAir Care Leasing LLC · Lamar, COBuilt 1991 · S/N 402-0815 N455MMMiklus Enterprises LLC · Middletown, DEBuilt 1980 · S/N 31T-8020087 N455PAMcginty Flying Service LLC · Jones, LABuilt 2006 · S/N 602-1141 N455RANorrland Partners LLC · Hillsboro, NDBuilt 2024 · S/N 802-1167 N455RSTfr Inc · Steamboat Springs, COBuilt 2005 · S/N 4697214 N455SGDdog LLC · San Angelo, TXBuilt 2001 · S/N 4697096 N4567SBoyle Flying Service Inc · Boyle, MSBuilt 2014 · S/N 802A-0571 N456LAJaj Flying LLC · Sutton, NEBuilt 2005 · S/N 602-1131 N457ATAeronautical Technologies Inc · Clovis, NMBuilt 2005 · S/N 802A-0201 N458RANorrland Partners LLC · Hillsboro, NDBuilt 2025 · S/N 802A-1212 N459RASilver Wings Flying Company LLC · Littlerock, WABuilt 2025 · S/N 802A-1243 N45FLRegistered aircraftBuilt 1993 · S/N NC-45 N4612JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2011 · S/N 602-1203 N461BBFlite Level Zero LLC · Stanfield, ORBuilt 2000 · S/N 4697016 N461JADesign Builds LLC · West Point, VABuilt 2003 · S/N 4697168 N461VFFlight International Corp Trustee · Flagstaff, AZS/N 46-8408049 N465MENorthlake Capital LLC · Ridgeland, MSBuilt 2005 · S/N 4697233 N465SKAv8 LLC · Paso Robles, CABuilt 2000 · S/N 4697013 N465TASouthwest Aviation Specialties LLC · Tulsa, OKS/N LJ630 N465TPMountain Holding Inc · Cody, WYBuilt 2005 · S/N 4697204 N468SPPacific Mission Aviation · Hagatna, GUBuilt 1998 · S/N BB1639 N468ZBBrown Helicopter Inc · Pensacola, FLBuilt 1988 · S/N 760345 N469BUnited States Construction Corporation · Pompano Beach, FLBuilt 1978 · S/N LJ-803 N469LACounty Line Flying Service Inc · Coy, ARBuilt 2012 · S/N 802A-0469 N469SBK-Town Aviation LLC · Louisville, TNBuilt 2003 · S/N 4697162 N46AEBank Of Utah Trustee · Salt Lake City, UTBuilt 1999 · S/N LJ-1582 N46CECentury Equipment Company Inc · Salt Lake City, UTBuilt 1994 · S/N BB1492 N46MEFishlover'S Management LLC · Chandler, AZBuilt 2005 · S/N 4697207 N46PLAvcorp Leasing Inc Trustee · Wilmington, DEBuilt 2001 · S/N 4697054 N470KAKerola Aviation Inc · Masury, OHBuilt 1993 · S/N FL-109 N470MMSfc Global Supply Chain Inc · Marshall, MNBuilt 2000 · S/N UE-394 N4712JCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 2013 · S/N 602-1225 N471HKSak II LLC · Miller, SDBuilt 2021 · S/N 802A-0883 N473FSShannon Agricultural Flying Inc · Clarksdale, MSBuilt 2012 · S/N 802A-0473 N473QHBrown Helicopter Inc · Pensacola, FLBuilt 1986 · S/N 760331 N473TWNv5 Geospatial Inc · Sheboygan Falls, WIBuilt 2001 · S/N 208B0894 N474HAg Solutions Of West Texas LLC · Roby, TXBuilt 2006 · S/N 802-0252 N474LACat Agri Aviation Inc · Walnut Ridge, ARBuilt 2012 · S/N 802A-0474 N474LCAlpine Aviation Inc · Provo, UTBuilt 1993 · S/N UE-74 N4757SBombay Glass Corp · Depoe Bay, ORS/N 4697006 N476XPMatonti James Robert · BanglamungRegistration ineffective or invalidBuilt 1968 · S/N 2040 N477HCParish Air Inc · San Diego, CABuilt 2003 · S/N 4697171 N477JMBehrens Aircraft Leasing LLC · Waukesha, WIBuilt 1979 · S/N BB-538 N477XPParaclete Aviation LLC · Raeford, NCBuilt 2000 · S/N 208B0833 N478CRAlg Aircraft LLC · Delano, CABuilt 1997 · S/N LJ-1474 N479BCm Aviation LLC · Corsicana, TXBuilt 2002 · S/N FL-338 N479SAEarthcom Inc · Williamston, MIBuilt 1967 · S/N LJ215 N479VATactical Aviation Inc · Wilmington, DEBuilt 1998 · S/N BB1601 N47CLAircraft Structures International Corp · Enid, OKBuilt 1987 · S/N 208B0033 N481ZGalazy Lift II LLC · New York, NYBuilt 1973 · S/N LW-52

Back to AD 2016-05-13