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.

N98710Skywarrior Flight Training Inc · Pensacola, FLBuilt 1985 · S/N 17276337 N98714Yellow Jacket Flying Club Inc · Chamblee, GABuilt 1984 · S/N 17276338 N9871DGolden Eagle Outfitters Inc · Delta Jet, AKBuilt 1959 · S/N 18-6889 N9871KBeverly Flight Center LLC · Middleton, MABuilt 1977 · S/N 28-7816200 N9871WLemerande Alan Robert Jr · Jefferson City, MOBuilt 1967 · S/N 28-23390 N9872JWagner Timothy A · Port Trevorton, PABuilt 1980 · S/N 17273944 N98731Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276341 N98738Bas Part Sales LLC · Greeley, COBuilt 1985 · S/N 17276342 N9873QMf Aviation Inc · Reston, VABuilt 1975 · S/N 17265817 N9873UCheetah Flyers LLC · Huntersville, NCS/N AA5A0273 N9873VChester Charter Inc · Chester, CTBuilt 1974 · S/N 17264539 N98749Howes Richard D · Mountain Home, IDBuilt 1978 · S/N 44-7995104 N9874DMinow Ranch Inc · Olive, MTBuilt 1959 · S/N 18-6895 N9874EBlust Henry A · Arlington, VABuilt 1979 · S/N 17272282 N9874GKorn Jeffrey J · Marietta, GABuilt 1971 · S/N 17259774 N9874QRodas Mary P · Blue Jay, CAS/N 17265818 N9874VSisler Allen R · Terra Alta, WVBuilt 1974 · S/N 17264540 N9874WMcanally Cameron F · Battle Ground, WABuilt 1967 · S/N 28-23394 N9875DMunich Tristan S · Yakutat, AKBuilt 1959 · S/N 18-7009 N9875G1 Aircraft LLC · Kissimmee, FLBuilt 1971 · S/N 17259775 N9875MKaelin Robert A · Fayetteville, ARBuilt 1972 · S/N 17260575 N98763Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1985 · S/N 17276344 N98769American Patrols Inc · Midland, TXBuilt 1985 · S/N 17276345 N9876GKentucky Lake Aviation LLC · Huntingdon, TNBuilt 1971 · S/N 17259776 N9876QRegistered aircraftBuilt 1975 · S/N 17265820 N9876VDelhotal Raymond K · West Brooklyn, ILBuilt 1974 · S/N 17264541 N9876WFoster John D · Grapevine, TXBuilt 1967 · S/N 28-23396 N98772Solberg Aviation Co Inc · Whitehouse Station, NJBuilt 1985 · S/N 17276347 N98774Simplifly LLC · Mesa, AZBuilt 1985 · S/N 17276349 N98776Melbourne Flight Training LLC · Melbourne, FLBuilt 1985 · S/N 17276350 N9877BAndra Joshua Corey · Riverton, UTBuilt 1982 · S/N 172RG1066 N9877DAdams Bob L · Eagle River, AKBuilt 1959 · S/N 18-6899 N9877GRowse Larry G · Plain City, OHBuilt 1971 · S/N 17259777 N9877UNaval John A · Auburn, WABuilt 1976 · S/N AA5A0277 N9878GRoyal Aviation Academy LLC · Sarasota, FLBuilt 1971 · S/N 17259778 N9878QNesland Patricia M · Burton, WAS/N 17265822 N9878URock N Roll Flying Club LLC · Omaha, NEBuilt 1976 · S/N AA5A0278 N9878WBenton Michael L · Gilbert, SCBuilt 1967 · S/N 28-23398 N9878YWaterman David N · Amery, WIS/N 7KC-3 N98792Stanzione Daniel F · Antelope, CABuilt 1985 · S/N 17276355 N98795Richmor Aviation Inc · Scotia, NYBuilt 1985 · S/N 17276357 N9879DGlenwood Farm LLC · Edgerton, MOBuilt 1959 · S/N 18-6901 N9879QCoker Design Group LLC · Campobello, SCS/N 17265823 N987ACKnight Tracy D · Reno, NVBuilt 2004 · S/N 987 N987BBTime Building LLC · Lake Oswego, ORBuilt 1988 · S/N 1004 N987EDupre Alan A · Shelbyville, KYBuilt 1990 · S/N 01 N987JBCassill Aircraft Leasing Inc · Cedar Rapids, IAS/N 987JB N987PGriffith Robert G · Sacramento, CABuilt 2001 · S/N 2133 N987TReady Aim Flyer LLC · New Castle, DES/N TD-405 N9880GHewlett John · Columbus, OHBuilt 1971 · S/N 17259780

Back to AD 79-10-03 R2