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.

N292JEEquinoxx Flight Systems LLC · Duluth, GABuilt 2022 · S/N 2881547 N292LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020014 N292LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881182 N292MGGeorgia Aviation Authority · Eastman, GABuilt 2014 · S/N 2843776 N292WRabbitt Timothy N · Austin, TXBuilt 2026 · S/N 28010001 N292WCColorado Mesa University · Grand Junction, COBuilt 2022 · S/N 28020053 N2933AFlying Particles Inc · Livermore, CABuilt 1979 · S/N 28-7916549 N2933VJones David T · Las Vegas, NVBuilt 1979 · S/N 28-7916551 N2934CPolte Steven J · Knoxville, TNBuilt 1979 · S/N 28-7916554 N2935GWilliams Herbert B Jr · Pensacola, FLBuilt 1979 · S/N 28-7990560 N2935NMartineau Robert Tyler · Crested Butte, COBuilt 1979 · S/N 28-7990562 N2935SJacksonville Airport Authority · Jacksonville, ILBuilt 1979 · S/N 28-7990563 N2935UBraner Richard C · Oakdale, CABuilt 1979 · S/N 28-7990565 N2935VHungerford Mark T · Swanton, VTBuilt 1979 · S/N 28-7990566 N2936QA&J Aircraft Leasing Inc · Burlington, COS/N 28-7716126 N2937NDelaware State University Aviation Program · Dover, DEBuilt 1979 · S/N 28-7916559 N2937QCharles Sargent Irrigation Inc · Broken Bow, NES/N 28-7716127 N2937RCross Winds Flying Club Inc · Bloomington, ILBuilt 1979 · S/N 28-7916560 N2937XOrtega Tobin W · Juneau, AKBuilt 1979 · S/N 28-7990567 N2938FFly Gateway Aviation Institute · New Castle, DES/N 28-7990573 N2938UArcher Two Aviation LLC · Walnut Creek, CABuilt 1979 · S/N 28-7990574 N2939JCaballeros Aircraft LLC · Snohomish, WABuilt 1979 · S/N 28-7990576 N2939Q7777 Aviation LLC · Bartow, FLS/N 28-7790425 N293FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844176 N293HPThree View Flyers LLC · Hauppauge, NYBuilt 2004 · S/N 2843603 N293LAPiper 3 LLC · Chestnut Ridge, NYBuilt 2021 · S/N 28020015 N293MGGeorgia Aviation Authority · Eastman, GABuilt 2015 · S/N 2844155 N293WCColorado Mesa University · Grand Junction, COBuilt 2022 · S/N 28020054 N2940QSkyhawk Flying Club Inc · Omaha, NES/N 28R-7737044 N2941LWells Joseph L · Ashburn, VABuilt 1979 · S/N 28-7916564 N2941UBaldasaro John · Clifton Park, NYBuilt 1979 · S/N 28-7916566 N2942RBright Michael R · Whitehall, MIBuilt 1979 · S/N 28-7916571 N2942TCentral Minnesota Aviation LLC · Paynesville, MNBuilt 1979 · S/N 28-7990577 N2945QWarrior Aviation Lc · Prairie Village, KSS/N 28-7716128 N2946MAir-Ag Inc · Tarboro, NCBuilt 1977 · S/N 28-7816325 N2946QHess Kenneth J · Kearneysville, WVS/N 28-7716129 N2948QMartin John Michael · Kingwood, TXBuilt 1977 · S/N 28-7790427 N294FSBoard Of Trustees Of Southern Illinois University · Murphysboro, ILBuilt 2018 · S/N 2844177 N294PACoco Aircraft Inc · Merritt Island, FLBuilt 2002 · S/N 2843504 N2950GLcc East LLC · Freehold, NJBuilt 1979 · S/N 28-7916572 N2950PFarrell Brian M · Vienna, VABuilt 1979 · S/N 28-7916576 N2950WTaglilatelo Dale R · Cocoa, FLBuilt 1979 · S/N 28--7916577 N2952YPreston Marty D · South Bend, INBuilt 1979 · S/N 28-7990580 N29535Clouse Tyler Woods · Forest City, IABuilt 1979 · S/N 28-7990448 N29537Garcia John C · Peoria, AZBuilt 1979 · S/N 28-7990449 N2953UClarkson Fredrich A · Oro Valley, AZBuilt 1979 · S/N 28-7990582 N2954NLewman Daniel O Jr · Summit, MSBuilt 1979 · S/N 28-7990586 N2955MRls Rental Co DBA · Joplin, MOBuilt 1977 · S/N 28-7816326 N2956PVann Dudley Carroll · Greenville, NCBuilt 1979 · S/N 28-7916583 N2956RFlightline LLC · Summerville, SCBuilt 1979 · S/N 28-7990588

Back to AD 2016-07-21