Skip to content

Registered aircraft · 40,395

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.

N158NDSkyborne Airline Academy Inc · Vero Beach, FLBuilt 1998 · S/N 2842030 N158PTPilot Training Center LLC · Miami, FLBuilt 1989 · S/N 2841150 N158SBTargosz Andrew H · Orland Park, ILBuilt 1998 · S/N 1248-98 N158SQGriffith Aviation Inc · Griffith, INBuilt 1978 · S/N ME-86 N158SRDe Souza Ferdinand E · El Prado, NMS/N 630 N158WUYale Companies LLC DBA · Indianapolis, INBuilt 2002 · S/N 4496158 N1590JTidwell Kevin C · Kennesaw, GABuilt 1967 · S/N 28-23999 N1590VWingsleasing LLC · Wichita, KSBuilt 1974 · S/N 17263684 N15914Studt Joseph Floyd · Rockvale, COBuilt 1972 · S/N 28-7325197 N15916Marianas Air Transfer Inc · Tinian, MPBuilt 1972 · S/N 28-7325199 N15918Ramseier Peter A · Imperial Beach, CAS/N 28-7305185 N1591EWingsleasing LLC · Wichita, KSBuilt 1978 · S/N 17271057 N1591JWingard Edward J · Powell, OHBuilt 1968 · S/N 28-24001 N1591VAviation Academy LLC · Wichita, KSBuilt 1974 · S/N 17263685 N159274dw Interests LLC · Longview, TXBuilt 1973 · S/N 28-7325202 N15928Bussell Matthew W · Reno, NVBuilt 1973 · S/N 28-7305187 N15929Cs Flying Ltd · Grafton, OHBuilt 1972 · S/N 28-7305188 N1592RWilliams Brian S · Marietta, GABuilt 1975 · S/N AA5B-0092 N1592VGates Kenneth A · Lake Isabella, CABuilt 1974 · S/N 17263686 N1592XN2211z LLC · Lantana, FLBuilt 1975 · S/N 28-7515427 N15930Rogers Aviation LLC · Florence, SCBuilt 1973 · S/N 28-7305189 N15933Flaps Inc · White Bear Lake, MNBuilt 1973 · S/N 28-7325203 N15935Stahl Dennis E · Wood Dale, ILBuilt 1973 · S/N 28-7305190 N15936Brown Norman C · Kewanee, ILS/N 28-7305191 N1593JRindeikis Bron · Sugar Grove, ILS/N 28-24003 N1593VBarrie Woodrow L · Oxford, MIBuilt 1974 · S/N 17263687 N15943Edgerton Eddie Lee · Midwest City, OKBuilt 1973 · S/N 28-7325208 N15944Habit Samuel P · Kokomo, INBuilt 1973 · S/N 28-7305193 N15945Newton Flying Club Inc · Collinsville, MSBuilt 1972 · S/N 28-7305194 N15946Leading Edge Inc · Cottonwood Heights, UTBuilt 1973 · S/N 28-7305195 N1594UFarmer Michael E · Greer, SCBuilt 1976 · S/N 17267176 N15955Air Wings Enterprise LLC · Roca, NEBuilt 1973 · S/N 28-7325210 N15956Hanson Mark E · Griffin, GABuilt 1973 · S/N 28-7305196 N15957Jones John E Jr · Metter, GABuilt 1973 · S/N 28-7305197 N1595RImpulsion Unlimited Inc · Huddleston, VABuilt 1975 · S/N AA5B-0095 N15962Romero Jason Nathanial · Broken Arrow, OKS/N 28-7325213 N15966Acosta Aaron · El Paso, TXBuilt 1973 · S/N 28-7325214 N15968Culberson Donald J · Orange Park, FLBuilt 1973 · S/N 28-7305200 N1596ETeam 172-03 LLC · Warsaw, INS/N 17271060 N1596JWard Lawrence G · Mckenzie, ALBuilt 1941 · S/N 28-24007 N1596RTc Aviation Ltd · Fairbanks, AKBuilt 1975 · S/N AA5B-0096 N15975Bourgeois David · Westminster, MABuilt 1973 · S/N 28-7305226 N15976Lake Life Aviation LLC · Yukon, OKBuilt 1973 · S/N 28-7305203 N1597JLs Aviation LLC · Searcy, ARS/N 28-24008 N15984Hewitt Jeremy K · West Jordan, UTBuilt 1973 · S/N 28-7325218 N1598JHassard Maitland · Goodyear, AZBuilt 1967 · S/N 28-24009 N1598RJam Cat LLC · Orlando, FLBuilt 1975 · S/N AA5B-0098 N15994Self Thomas C · Madisonville, TNS/N 28-7325222 N1599RLuka Robert E · Berea, KYBuilt 1967 · S/N 28-3845 N1599XDuffys Aircraft Sales & Leasing Inc · Neillsville, WIBuilt 1975 · S/N 28-7505245

Back to AD 79-10-03 R2