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.

N690HAAims Community College · Greeley, COBuilt 2025 · S/N 2881865 N690LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881196 N690PMMiddlefield Farm And Garden Co · Middlefield, OHBuilt 2024 · S/N 2881728 N6911PMalo Blake Ridgway Trustee · Portland, ORBuilt 1985 · S/N 28-8590050 N6912JHammond Brian M · Gresham, ORBuilt 1976 · S/N 28-7690427 N6913JFlight Time LLC · Conover, NCBuilt 1976 · S/N 28-7690428 N6913RAirplane And Drone Flight Instruction LLC · Orlando, FLBuilt 1985 · S/N 28-8590054 N6914JKreppel Frederick W · Wayne, PABuilt 1976 · S/N 28-7690429 N6915TSpier Samuel · Carson City, NVBuilt 1985 · S/N 28-8590058 N69165Locaero Services Inc Trustee · Wilmington, DEBuilt 1985 · S/N 28-8516060 N6917DOlds Forge Flyers Inc · Lansing, MIBuilt 1985 · S/N 28-8590061 N6917GMarvell Aviation LLC · Marvell, ARBuilt 1985 · S/N 28-8590062 N691LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881197 N6920GValley Boys LLC · Lakeville, MNBuilt 1985 · S/N 28-8590065 N6922JSystematic Management And Flight Training LLC · Kankakee, ILBuilt 1976 · S/N 28-7690431 N692LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881217 N6930JSkypark Aero Club Inc · Troy, OHBuilt 1976 · S/N 28-7690432 N6931JMissouri Valley Flying Club Inc · Culbertson, MTBuilt 1976 · S/N 28-7690433 N6932FBruns Luke J · Flower Mound, TXBuilt 1976 · S/N 28-7790174 N6938JBerry Joe O · Franklin, TNBuilt 1977 · S/N 28-7716001 N693LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881218 N6942JAndromeda Air LLC · Houston, TXBuilt 1976 · S/N 28-7690434 N6944CUpdraft Leasing LLC · Tea, SDBuilt 1978 · S/N 28-7816442 N6948C48 Charlie LLC · Columbia, MDS/N 28R-7837177 N694LHChristiansen Aviation LLC · Wilmington, DEBuilt 2019 · S/N 2881219 N694RMTavel Charles · Cave Creek, AZBuilt 2005 · S/N 2843607 N6952CSnoz Inc · Sharon, MABuilt 1978 · S/N 28R-7837178 N6956JJuliet Sky LLC · Sioux City, IABuilt 1976 · S/N 28-7690439 N6958JAkin Enterprises Inc · Greensboro, GABuilt 1976 · S/N 28-7690441 N695APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843782 N695FParagon Flight Training Co · Fort Myers, FLBuilt 2025 · S/N 28020237 N695LHJrnd Corp · Lewes, DEBuilt 2023 · S/N 2881628 N6965JDanik LLC · Harper Woods, MIBuilt 1976 · S/N 28-7690442 N6966CSchlichter Timothy J · Huntsville, ALBuilt 1978 · S/N 28-7816443 N6966JTwo Mile Final LLC · Spring, TXBuilt 1976 · S/N 28-7690443 N6967CUp And Down Aviation LLC · Perry, GAS/N 28-7816444 N6969VArcher II Management LLC · Hernando, MSBuilt 1979 · S/N 288090137 N696APiper Archer Three LLC · Wilmington, DEBuilt 2014 · S/N 2843783 N696HJCold Rain Inc · Carleton, NEBuilt 1979 · S/N 28-8090190 N696LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881629 N6972JBicker Farms Lllp · Tioga, NDBuilt 1976 · S/N 28-7690445 N6979JImani Cameron · Lexington, KYS/N 28-7690446 N697CACoast Flight Training And Management Inc · Dallas, TXBuilt 2019 · S/N 2881133 N697LHFf22 LLC · Scottsdale, AZBuilt 2023 · S/N 2881686 N6980JNulton Enterprises LLC · Johnstown, PABuilt 1976 · S/N 28-7690447 N6995CDetert Bradley · Valparaiso, INBuilt 1978 · S/N 28R-7837180 N6997JBailey Kevin R · Crown Point, INBuilt 1976 · S/N 28-7690452 N6998JMt Aircraft Sales And Leasing LLC · Wilmington, DEBuilt 1976 · S/N 28-7690453 N699DWDw Flight LLC · Columbus, OHBuilt 2005 · S/N 2843612 N699LGN699 Lg LLC · Mahtomedi, MNBuilt 1999 · S/N 2843258

Back to AD 2016-07-21