Registered aircraft · 1,373

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-04-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:2018-04-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:2018-04-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:2018-04-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:2018-04-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:2018-04-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.

N228LWhite Plains Aviation LLC · Saratoga Springs, NYBuilt 2008 · S/N 20194 N228PKKjp LLC · Eugene, ORBuilt 2018 · S/N 20730 N228YAnderson Equipment Co · Latrobe, PABuilt 2014 · S/N 20447 N229BPWhisky Echo Aviation LLC · Aurora, COBuilt 2018 · S/N 20741 N22SNSfw LLC · Las Vegas, NVBuilt 2023 · S/N 2275 N22XZSaetta LLC · Lehi, UTBuilt 2010 · S/N 20294 N230LFLevforce Aviation LLC · Boca Raton, FLBuilt 2024 · S/N 55020213 N234GFLaw Force LLC · Southfield, MIBuilt 2024 · S/N 21006 N234JKAfter The Bell LLC · Baltimore, MDBuilt 2015 · S/N 55000022 N235EFEaf Air LLC · Detroit, MIBuilt 2013 · S/N 20434 N235UBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 2214 N243LSBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 21028 N245AEN318mm LLC · Topeka, KSBuilt 2008 · S/N 20245 N247FSNcm Leasing LLC · Naples, FLBuilt 2005 · S/N 20068 N247JDMontana Associates LLC · Spartanburg, SCBuilt 2015 · S/N 20598 N247JJStillwater Aviation LLC · Nashville, TNBuilt 2023 · S/N 20983 N247MBMiwd Flight LLC · Harrisburg, PABuilt 2015 · S/N 20579 N248MLMglctt Inc · Raleigh, NCBuilt 2012 · S/N 20378 N24FEFederal Express Leasing Corp · Memphis, TNBuilt 2012 · S/N 20355 N24GWRegistered aircraftBuilt 2022 · S/N 2257 N24YPYankee Papa Aircraft LLC · Artesia, NMBuilt 2019 · S/N 55000082 N250AGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 20793 N250DNRegistered aircraftRegistration pendingBuilt 2018 · S/N 20728 N250LCBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 55000041 N2510DD Squared Ventures LLC · Scottsdale, AZBuilt 2012 · S/N 20346 N251FTSc Aviation Partners LLC · Boston, MABuilt 2011 · S/N 20315 N254DV600 Aviation LLC · Grand Rapids, MIBuilt 2021 · S/N 55020146 N255BVShurtape Technologies LLC · Hickory, NCBuilt 2016 · S/N 20644 N255DV600 Aviation LLC · Grand Rapids, MIBuilt 2021 · S/N 55020147 N256GGChantilly Crushed Stone Inc · Chantilly, VABuilt 2008 · S/N 20204 N256WBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 20079 N257RYRyan Air LLC · Dallas, TXBuilt 2014 · S/N 20506 N258DV600 Aviation LLC · Grand Rapids, MIBuilt 2023 · S/N 55020180 N259BGBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 55010138 N259FGBank Of Utah Trustee · Salt Lake City, UTBuilt 2012 · S/N 2015 N25MBBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 20622 N25YBTabletop LLC · Billings, MTBuilt 2025 · S/N 21095 N261FXKenningham Daryl · Cleveland, OHBuilt 2025 · S/N 55010166 N262FXQuantum Entertainment LLC · Cleveland, OHBuilt 2025 · S/N 55010171 N263FXLeap Air LLC · Cleveland, OHBuilt 2025 · S/N 55010175 N264FXKieffer Stephen G · Cleveland, OHBuilt 2025 · S/N 55010172 N265FXFlexjet LLC · Cleveland, OHBuilt 2025 · S/N 55010178 N265KCorporate Jet Leasing Co LLC · Wichita, KSBuilt 2009 · S/N 20265 N265SJN529tm LLC · Fairfax, VABuilt 2010 · S/N 20308 N267620407 Holdings LLC · Atlanta, GABuilt 2013 · S/N 20407 N267FTFifth Third Bank Na · Cincinnati, OHBuilt 2016 · S/N 20626 N267FXFlexjet LLC · Cleveland, OHBuilt 2025 · S/N 55010185 N268CLEmbraer Executive Aircraft Inc · Melbourne, FLBuilt 2026 · S/N 55020273 N268FXBison Travel LLC · Cleveland, OHBuilt 2025 · S/N 55010189 N269FXLovett Richard · Cleveland, OHBuilt 2025 · S/N 55010183

Back to AD 2018-04-13