Skip to content

Registered aircraft · 40,394

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

N83LMJohannsen Gregory A · Salina, KSBuilt 1964 · S/N 28-1563 N83MAJones Stephen W · Tampa, FLBuilt 1978 · S/N AA5B0997 N83MTApplebaum Steven · Morton Grove, ILBuilt 1996 · S/N 387 N83MZZeitlin Marc J · Tehachapi, CABuilt 2002 · S/N 386 N83PYDecino Robert D · Fritz Creek, AKS/N 18-8559 N83RQBlais Michel · Jackson, TNBuilt 1978 · S/N AA5B0887 N83TXPike Alan D · South Portland, MEBuilt 1983 · S/N 8-0110 N83WJSikes Randell D · Dandridge, TNBuilt 1983 · S/N 758 N83ZCrittenden William F · Spokane Valley, WAS/N TD-199 N84001Darcy Aviation LLC · Danbury, CTBuilt 1985 · S/N 28-8516080 N84007Smith Michael W · Sharon, CTBuilt 1981 · S/N 28-8190259 N8400LInstant Print Signs & Designs LLC · Kalispell, MTBuilt 1968 · S/N 17256600 N8400SParks Perry A · Goodell, IAS/N 28-8116251 N84019Snodgrass William D · Moberly, MOFirst renewal noticeBuilt 1969 · S/N 17258303 N8401FSchriner Keith D · Lanark, ILBuilt 1976 · S/N 28-7790238 N8401LBlack Baron Air LLC · Kalispell, MTS/N 17256601 N8401RLaplante David W · New Baltimore, MIBuilt 1966 · S/N 28-22278 N8401TWingsleasing LLC · Wichita, KSBuilt 1981 · S/N 28-8290033 N84024Maurano Michael R · Long Island, VABuilt 1969 · S/N 17258304 N84026Smith William A Jr · Tulsa, OKBuilt 1969 · S/N 17258305 N8402CConner W Larry · Los Lunas, NMBuilt 1976 · S/N 28-7625112 N8402LVan Bortel Inc · Victor, NYBuilt 1968 · S/N 17256602 N8402RLivengood Leasing Co LLC · Mesa, AZBuilt 1966 · S/N 28-22279 N8402WAnderson Thomas · La Quinta, CABuilt 1965 · S/N 28-2616 N84036Wings Over Texas Holdings LLC · Denton, TXBuilt 1969 · S/N 17258308 N8403LAarow Aircraft Leasing LLC · Mcminnville, ORBuilt 1983 · S/N 0347 N8403RSenmounnarath Sam · Murfreesboro, TNBuilt 1966 · S/N 28-22280 N84048Kyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1969 · S/N 17258314 N84050Alpenglow Air 2 LLC · Anchorage, AKBuilt 1969 · S/N 17258315 N84054Far Horizons LLC · Ravenel, SCBuilt 1981 · S/N 28-8116257 N8405BMiloud Chadd K · Fort Worth, TXBuilt 1981 · S/N 28-8116252 N8405RShields Parker · Port Orange, FLBuilt 1966 · S/N 28-22345 N8405SAlston Tony · Midland, TXBuilt 1981 · S/N 28-8116255 N8405WTaylor Dale E · Kimball, SDBuilt 1965 · S/N 28-2621 N8406244 Flyers · Harlowton, MTBuilt 1969 · S/N 17258319 N84063Rothermel Donald M · Mokena, ILBuilt 1969 · S/N 17258320 N8406AColorado High Flyers LLC · Colorado Springs, COBuilt 1981 · S/N 28-8290017 N8406HP A Flying LLC · Pueblo, COFirst renewal noticeBuilt 1981 · S/N 28-8190269 N8406LVee Neal Aviation · Latrobe, PABuilt 1968 · S/N 17256606 N8406WWright Jordan M · York, SCBuilt 1965 · S/N 28-2623 N84071Roadrunner Flight School LLC · Farmington, NMBuilt 1969 · S/N 17258322 N84072Ferre Taylor · Kirkland, WABuilt 1969 · S/N 17258323 N84076Third Step 3 LLC · Gilbert, AZBuilt 1969 · S/N 17258325 N8407DRegistration Pending · Manassa, CORegistration pendingBuilt 1957 · S/N 22-5660 N8407LPlainwell Aviation And Stem Academy · Kalamazoo, MIBuilt 1968 · S/N 17256607 N8407MJohnson Michele J · Buena Vista, COBuilt 1969 · S/N A1500107 N8407PMark Gary Flying Service Inc · Inverness, MSBuilt 1965 · S/N 18-8295 N8407WIsland Flyers LLC · Apopka, FLBuilt 1983 · S/N 58 N84082Weinheimer Paul T · Amarillo, TXBuilt 1969 · S/N 17258326 N84086Smoky Mountain Flyers · Murphy, NCBuilt 1969 · S/N 17258327

Back to AD 79-10-03 R2