Skip to content

Registered aircraft · 8,138

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:96-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-01-R1') 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:96-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-01-R1')
  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:96-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:96-10-01-R1')
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.

N1123WThiel Jonathan Ronald · Billings, MTS/N 28-771 N112JMGuzman John · China Spring, TXBuilt 1975 · S/N 28-7525187 N1144XFly Texas Sky LLC · Arlington, TXBuilt 1975 · S/N 28-7505215 N114CFAw Chartering LLC · Franklin, TNBuilt 1974 · S/N 28-7505080 N1157XAscend Aviation LLC · Bountiful, UTBuilt 1975 · S/N 28-7525294 N1159XBarrett Tyler J · Cullman, ALS/N 28-7505217 N115JAFarmer Stephen E · Tullahoma, TNBuilt 1967 · S/N 28-22953 N1167XHoover Adam A · Sugarloaf, PABuilt 1975 · S/N 28-7525295 N1168XJz Air LLC · Brooklyn, NYBuilt 1975 · S/N 28-7505219 N1178XN1178x LLC · Dover, DEBuilt 1975 · S/N 28-7505220 N117DWFerrand Kathy M · Cornelia, GABuilt 1973 · S/N 28-7325669 N117MTHinkle Robert J · Caldwell, IDS/N 28-21374 N1184DZwick Noah Geary · Dunkirk, MDBuilt 1967 · S/N 28-23130 N1184XLairson Samuel E III · Ocean City, NJBuilt 1975 · S/N 28-7505221 N1185XWilliamson Flying Club Inc · Williamson, NYBuilt 1975 · S/N 28-7505222 N1188TAbrams Jeffrey Scott · Phoenix, AZBuilt 1964 · S/N 28-1883 N1196XMedic Choppers LLC · Springdale, ARS/N 28-7525279 N1198XDiscover Aviation Center LLC · Elyria, OHBuilt 1975 · S/N 28-7505223 N119A2is Partners LLC · Vero Beach, FLBuilt 1969 · S/N 28-25947 N119HPValiair Limited Company Trustee · Casper, WYBuilt 1966 · S/N 28-21570 N119JDUSA Wiltshire LLC · Pembroke Pines, FLBuilt 1969 · S/N 28-25406 N11GERusso James F · Liberty, SCBuilt 1972 · S/N 28-7325081 N11GKBaden Michael · Waxhaw, NCS/N 28-23403 N11GNHaley James M Trustee · Edmond, OKBuilt 1973 · S/N 28-7305330 N11HAVintage Aero Inc · Brandon, FLBuilt 1973 · S/N 28-7305338 N11KAlbers Edward C · Burlington Flats, NYBuilt 1968 · S/N 28-4725 N11NTSabb Anthony · Wetumpka, ALBuilt 1972 · S/N 28-7205193 N1203TProfessional Locators & Acquisition Specialists Ll · Severance, COBuilt 1972 · S/N 28-7225420 N1204THigh Sky LLC · Ellensburg, WABuilt 1972 · S/N 28-7225421 N1205TAmerican Aircraft Management LLC · Irving, TXBuilt 1972 · S/N 28-7225422 N1206TCps 1 LLC · Pelham, ALBuilt 1972 · S/N 28-7205266 N1213TDyer Gary T · Reno, NVS/N 28-7225423 N1214TPost 8 Flight Opps Inc · Topeka, KSBuilt 1972 · S/N 28-7205268 N121ESWell Bilt Industries USA LLC · Ocala, FLBuilt 1971 · S/N 28-7125383 N121MDBaggarly Michael · Newnan, GABuilt 1969 · S/N 28-25613 N1226TLinde Glenn F Jr · Juneau, WIBuilt 1972 · S/N 28-7205269 N122HSMarbury Sherri E · Jackson, TNBuilt 1965 · S/N 28-2377 N1232TAlexander Charles W · Slidell, LABuilt 1972 · S/N 28-7225430 N1235SBarney Erick L · Jacksonville, ORBuilt 1967 · S/N 28-4306 N1237HGivens Timothy A · Collierville, TNBuilt 1976 · S/N 28-7725137 N123GEFlying Four Inc · Saint Petersburg, FLBuilt 1971 · S/N 28-7205062 N123JCDippolito Mario M · Sherwood, ARS/N 28-22500 N123SWBelschner Custom Meats · Amherst, NEBuilt 1972 · S/N 28-7305105 N1241TGale Richmond T · Tewksbury, MABuilt 1972 · S/N 28-7225433 N1242TDoblmaier Thomas J · North Wales, PABuilt 1972 · S/N 28-7205272 N124JCDestination Aviation LLC · Destin, FLBuilt 1965 · S/N 28-2340 N1250TStanley Natasha S · Lorton, VABuilt 1972 · S/N 28-7225436 N1251TMcvey Cindy M · Colts Neck, NJBuilt 1972 · S/N 28-7225437 N1260TRed Rock Flying School LLC · Mesa, AZBuilt 1972 · S/N 28-7225441 N1261TObrien Timothy D · Alplaus, NYBuilt 1972 · S/N 28-7205273

Back to AD 96-10-01 R1