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.

N8172ZAverka Steven D · Sutton, MABuilt 1980 · S/N 28-8090264 N8173DAaa Flying Service Inc · Wellington, TXBuilt 1957 · S/N 18-6097 N8173ESky Equity LLC · Woodbury, MNBuilt 1978 · S/N 17272147 N8173NJones Roy F · Benson, AZBuilt 1968 · S/N 28-25369 N8173WRoadrunner Flight School LLC · Farmington, NMS/N 28-2295 N81741Corsican Aviation LLC · Westfield, INBuilt 1980 · S/N 28-8090134 N81749Friend Aircare Inc · Washington, PABuilt 1982 · S/N 28-8290107 N8174MFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260574 N8174WJeffers Coreen · Bellmawr, NJBuilt 1965 · S/N 28-2298 N8175EHigh Planes Aviation LLC · Goodland, KSBuilt 1959 · S/N 1446 N8175HHowe Richard B · San Luis Obispo, CABuilt 1980 · S/N 28-8016292 N8176CShaffer Glenn · Vinemont, ALBuilt 1954 · S/N 18-3632 N81771Skyfusion II LLC · Atlanta, GABuilt 1980 · S/N 28-8090269 N8177NAspiras Dionisio O Jr · Rosharon, TXBuilt 1968 · S/N 28-25373 N8177WDavis James Warren · Albemarle, NCBuilt 1965 · S/N 28-2301 N8179HSam Air LLC · Daphne, ALBuilt 1982 · S/N 28-8216138 N8179NFletcher William J · Mason, NHBuilt 1968 · S/N 28-25375 N8179THill Jason M · Bakersfield, CABuilt 1960 · S/N 17556879 N8179WLynch Gary L · Ocala, FLBuilt 1965 · S/N 28-2303 N817ABHawaii Pacific Aviation Inc · Kailua Kona, HIS/N 1258 N817ACCannon Air Force Base - Aero Club · Clovis, NMBuilt 2003 · S/N 2842190 N817DHMastrangelo John A · Phoenix, AZBuilt 2003 · S/N 1341-2003 N817JVRusyniak Anthony J · Syracuse, NYBuilt 1995 · S/N 1283 N817KCCrawford Michael R · Gainesville, GABuilt 1976 · S/N AS-1 N817ZBennett Condon P · Stormville, NYBuilt 1976 · S/N 17266787 N81809Corporation Of The Catholic Archbishop Of Anchorag · Anchorage, AKBuilt 1980 · S/N 28-8016221 N8180MLeap Aviation Inc · Wilmington, DES/N 17260570 N8180WD And D Air Inc · Paola, KSBuilt 1965 · S/N 28-2305 N8181DMuleshoe Ranch Inc · Belle Fourche, SDBuilt 1957 · S/N 18-6116 N8181NBald Eagle Flying Club · South Portland, MEBuilt 1968 · S/N 28-25377 N8181XStelling William F · Fairbury, NEBuilt 1980 · S/N 28-8016301 N8182ERed Arrow Aviation LLC · Santa Teresa, NMBuilt 1978 · S/N 17272148 N8182NJlf Air Inc · Evansville, INBuilt 1969 · S/N 28-25378 N8182WSwillen Richard Carl · Easley, SCBuilt 1965 · S/N 28-2307 N81830Wilkins Raymond E · Osceola, IABuilt 1983 · S/N SH-436 N8183DReabe Robert E · Waupun, WIBuilt 1957 · S/N 18-6118 N8183NTucker Richard D · Locust, NCBuilt 1968 · S/N 28-25379 N81843Sorensen Paris K · Murrells Inlet, SCBuilt 1980 · S/N 28-8016174 N8184GAspire Aviation LLC · Farmingdale, NYBuilt 1979 · S/N 17273615 N8184WBaker John L · Killen, ALBuilt 1965 · S/N 28-2310 N8185ARiggin William J · Carterville, ILBuilt 1991 · S/N 18 N8185NWright Edward J Jr · San Antonio, TXBuilt 1969 · S/N 28-25382 N81866Wellness Flight LLC · Sarasota, FLBuilt 1980 · S/N 288016305 N8186NMorris Thomas L · Fairmont, WVBuilt 1969 · S/N 28-25383 N81876Purcell Diane Diez · Baton Rouge, LABuilt 1980 · S/N 28-8090283 N8187DSchmidt Darrell · Kimberly, IDBuilt 1957 · S/N 18-6122 N8187WViroqua Area Flyers Inc · Viroqua, WIS/N 28-2314 N8187XStevenson William E · Holton, KSBuilt 1980 · S/N 28-8016307 N81888Zion Thomas C · Middleboro, MABuilt 1981 · S/N 28-8116285 N8188CSlayden Steven M · Rhome, TXBuilt 1954 · S/N 18-3647

Back to AD 79-10-03 R2