Registered aircraft · 281

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:2018-07-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:2018-07-16') 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:2018-07-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:2018-07-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.

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:2018-07-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:2018-07-16')
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.

N100DAGreen Seed Technologies LLC · Orem, UTBuilt 2018 · S/N 62.078 N101SWSkywarrior Flight Training LLC · Pensacola, FLBuilt 2016 · S/N 42.N214 N107EBlue Goose Aviation LLC · Charleston, SCBuilt 2018 · S/N 62.106 N107NGMccarren Aviation LLC · Green Bay, WIBuilt 2015 · S/N 42.N171 N108NGRockhill Aerospace Inc · Molino, FLBuilt 2015 · S/N 42.N172 N112DMSbf Aviation LLC · Bardstown, KYBuilt 2021 · S/N 62.C034 N112NGWestern United Aviation LLC · Yacolt, WAS/N 42.N192 N113BKBlatt Oren · Houston, TXBuilt 2024 · S/N 62.C091 N116NGCarolina Garuda Services LLC · Wilson, NCBuilt 2011 · S/N 40.N016 N118CYIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2016 · S/N 62.031 N119APParker Stephen H · Marfa, TXBuilt 2011 · S/N 31031 N119DATanager Diamond LLC · Manhattan Beach, CABuilt 2020 · S/N 62.C029 N123AADivine Life · Houston, TXBuilt 2023 · S/N 62.252 N125NGNovember Golf LLC · Provo, UTBuilt 2015 · S/N 40.N261 N126NGFjr Consulting Inc · Reno, NVBuilt 2015 · S/N 42.N186 N137PSEclipse Financial LLC · Corpus Christi, TXBuilt 2025 · S/N 62.C094 N141DACinden LLC · Nashua, NHBuilt 2016 · S/N 42.N219 N141KEBoondock Enterprises LLC · Boise City, OKBuilt 2018 · S/N 62.C006 N142GSFort Wayne Aircraft LLC · Fort Wayne, INBuilt 2012 · S/N 42.NC003 N142NGFive Star Marketing Inc · Raleigh, NCBuilt 2006 · S/N 42.082 N143NGTiger Aggie Air LLC · Fredericksburg, TXBuilt 2013 · S/N 40.N143 N145DRSeascape Flyers Inc Trustee · Wilmington, DEBuilt 2021 · S/N 62.C037 N147TSTreacy Jonathan T · Oxford, MEBuilt 2006 · S/N 42.AC007 N149DA149da LLC · Normandy Park, WABuilt 2018 · S/N 62.092 N149PSIqt Aviation LLC · Colleyville, TXBuilt 2025 · S/N 62.C101 N151MABridgewater State University · New Bedford, MABuilt 2005 · S/N 42.063 N153TSAirplane Holding LLC · Huntington Station, NYBuilt 2006 · S/N 42.118 N154PSWr66 Aviation LLC · Homestead, FLBuilt 2025 · S/N 62.C096 N157DAFreedom Aero LLC · Wilmington, DEBuilt 2019 · S/N 62.C014 N157JClean Management LLC · Walterboro, SCBuilt 2024 · S/N 62.C090 N15ERAndro Richard L · Dallas, TXBuilt 2024 · S/N 62.C083 N167PSTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2025 · S/N 62.C103 N168PFJetnexa Eleven LLC · Gilbert, AZBuilt 2022 · S/N 42.N500 N176TSOld Glory Inc · Tulsa, OKBuilt 2006 · S/N 42.176 N181CWDiamond 42 N123 Magic Carpet Inc Trustee · Wilmington, DEBuilt 2014 · S/N 42 N123 N1836TAndromeda Air LLC · Houston, TXBuilt 2014 · S/N 42.N159 N1926EEmbry Riddle Aeronautical Univ Inc · Prescott, AZBuilt 2025 · S/N 42.N581 N19YZN524rg LLC · Wesley Chapel, FLBuilt 2023 · S/N 62.241 N1PPLevel One Trauma Pllc · Sherman, TXBuilt 2016 · S/N 42.N201 N212SADiamond Aircraft Sales U S A Inc · London OntarioBuilt 2026 · S/N 42.N623 N215EGbny LLC · Gasport, NYBuilt 2020 · S/N 62.C030 N21JNDiamond Aircraft Sales USA Inc · LondonBuilt 2025 · S/N 62.C106 N224UTJettech Consulting LLC · Houston, TXBuilt 2024 · S/N 62.302 N227RRTrinity Logistics Holdings LLC · Jacksonville, FLBuilt 2018 · S/N 62.086 N227SKAlf Ix LLC · Chicago, ILBuilt 2026 · S/N 42.N615 N230PASl Aviation LLC · Lakeville, MNBuilt 2023 · S/N 42.N516 N233AVWestwind School Of Aeronautics Phoenix LLC DBA · Goodyear, AZBuilt 2023 · S/N 42.N498 N234LMRegistered aircraftBuilt 2025 · S/N 42.N578 N2358N2358 LLC · Bellevue, WABuilt 2023 · S/N 62.C069 N236TSFisher Curtis R · Mankato, MNBuilt 2006 · S/N 42.AC022

Back to AD 2018-07-16