Skip to content

Registered aircraft · 5,443

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-07-21') 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-07-21') 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-07-21')
    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-07-21')
  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-07-21')
  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-07-21')
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.

N7115LAtp Aircraft 3 LLC · Wilmington, DEBuilt 2017 · S/N 2843915 N711NDFlight Leasing Corp · Wilmington, DEBuilt 2017 · S/N 2843881 N713LSMendel Joseph · Naperville, ILBuilt 1978 · S/N 28-7890400 N713NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843882 N713REAks Aviation LLC · Arroyo Grande, CABuilt 1983 · S/N 28-8316083 N713SQTransportation Solutions & Logistics Inc · Orlando, FLBuilt 2013 · S/N 2843735 N714NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843883 N7158CAeronauts Flying Club Inc · Newton, MABuilt 1975 · S/N 28-7690057 N715SCRunamuck LLC · New Orleans, LABuilt 2023 · S/N 2881625 N716GAtp Aircraft 9 LLC · Wilmington, DEBuilt 2021 · S/N 2881460 N716NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843885 N7171FFriedrich Richard L · Georgetown, TXFirst renewal noticeBuilt 1976 · S/N 28-7790184 N717VTN717vt LLC · Wayne, PABuilt 1982 · S/N 28-8316029 N7185FBrw Aircraft Inc · Matawan, NJBuilt 1976 · S/N 28-7790186 N718KTGeorgia Aviation Authority · Eastman, GABuilt 2007 · S/N 2843653 N718NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843852 N719NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2016 · S/N 2843854 N71DXGlobe Aero LLC · Lakeland, FLBuilt 2026 · S/N 28010071 N71LZGriffin Ralph J Jr · Thibodaux, LABuilt 1977 · S/N 28-7816275 N71PRCti Aircraft Leasing LLC · Memphis, TNS/N 2881302 N720GPCharlie Hotel Corp · Wilmington, DEBuilt 1977 · S/N 28-7790366 N720PAValiair Lc Trustee · Casper, WYBuilt 2000 · S/N 2843386 N720UOhio University · Albany, OHBuilt 2005 · S/N 2842223 N7210HMenzie Bradley J · Sublette, KSFirst renewal noticeBuilt 1976 · S/N 287690255 N721FJ8th Dimension Enterprises LLC · Aurora, ORBuilt 2021 · S/N 28020027 N721JDBrand Technicians LLC · Encino, CABuilt 2000 · S/N 2843410 N721NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881309 N721SMBlue Skies Flying Services Inc · Lake In The Hills, ILBuilt 2000 · S/N 2843337 N722AKInternational Air Services Inc Trustee · Carson City, NVBuilt 1992 · S/N 2890172 N722NDUnd Aerospace Foundation · Grand Forks, NDBuilt 2020 · S/N 2881310 N722TCSchmitz William C · Charleston, SCBuilt 1978 · S/N 28-7990127 N7232CVector Aviation LLC · Mentor, OHBuilt 1976 · S/N 28-7690061 N72383Niagarawings Aviation LLC · Niagara Falls, NYBuilt 1977 · S/N 28-7890141 N723AJCavorite Aviation LLC · West Jordan, UTBuilt 2005 · S/N 2843613 N723PC43rd Aviation Flying Club Inc · Norfolk, CTFirst renewal noticeBuilt 1998 · S/N 2843194 N724AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843790 N724CASouth Shore Flying Club Inc · South Weymouth, MABuilt 1999 · S/N 2843224 N724DWParagon Airplane Leasing Co · Fort Myers, FLBuilt 2023 · S/N 28020124 N724RStardust Aviation LLC · Farmingdale, NYBuilt 2003 · S/N 2843543 N7258CRegistered aircraftBuilt 1975 · S/N 28-7690063 N7259CN7259c LLC · Indianapolis, INBuilt 1975 · S/N 28-7690064 N725NDUniversity Of North Dakota · Grand Forks, NDBuilt 2023 · S/N 2881620 N726DFTactical Aviation LLC · Brownstown, MIBuilt 1981 · S/N 28-8216023 N726NDUniversity Of North Dakota · Grand Forks, NDBuilt 2021 · S/N 2881488 N727ACLong Island Aviators LLC · Seaford, NYBuilt 1977 · S/N 28-7890128 N727DEKennett Aerospace LLC · Kennett, MOBuilt 1978 · S/N 28-7816572 N728AMeridian Aircraft LLC · Wilmington, DEBuilt 2014 · S/N 2843791 N728NDUniversity Of North Dakota · Grand Forks, NDBuilt 2017 · S/N 2843886 N728TBAtd Pilot Training LLC · Kansas City, MOBuilt 1978 · S/N 28-7816536 N728WFReigh Galen R · Williamsburg, PABuilt 1979 · S/N 28-7916371

Back to AD 2016-07-21