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.

N3005DAirline Transport Professionals Corp Of USA · Wilmington, DEBuilt 1978 · S/N 44-7995140 N3005KEast Valley Flyers LLC · Chandler, AZBuilt 1978 · S/N 28-7990246 N3005TSkala Frank M · Wurtsboro, NYS/N 28-7916384 N3005ZStamp Christopher L · Rock Stream, NYBuilt 1959 · S/N 22-6956 N30063King Air Inc · Naknek, AKBuilt 1978 · S/N 28-7990082 N30064Avarix Inc · Cool, CAS/N 17701053 N30067Limbacher John P II · Cookeville, TNBuilt 1978 · S/N 28-7990083 N3006KPrescott Flying Club Inc · South Saint Paul, MNBuilt 1978 · S/N 28-7990247 N3006WJimenez Carlos · Davie, FLBuilt 1979 · S/N 28-7990360 N3007BStanly Business Consultants LLC · Albemarie, NCBuilt 1978 · S/N 28-7990134 N3007KC & B Partnership · Grand Junction, COFirst renewal noticeBuilt 1978 · S/N 28-7990248 N3008AMackenzie David Webb · Wilmington, DEBuilt 1978 · S/N 28-7916104 N3008BSedberry Jason A DBA · Kokomo, INBuilt 1978 · S/N 28-7990135 N3008EShore Gerald E · Inez, TXBuilt 1978 · S/N 17271401 N3008FShepherd Michael D · Rock Hill, SCBuilt 1978 · S/N 28-7916210 N3008UNaperville Flying Club Inc · Woodridge, ILBuilt 1979 · S/N 28-7990333 N30096Sirek David G · Fritch, TXBuilt 1968 · S/N 17701057 N30098Humbert Randy M · Tumtum, WAS/N 17701059 N3009UEdgar Holly A · Tigard, ORBuilt 1979 · S/N 28-7990334 N300BKManning Ryan E · Watsonville, CABuilt 1976 · S/N AA5B0335 N300CACharlie Alpha LLC · Midland, MIBuilt 1973 · S/N 28-7305324 N300CMBoehm Tristan C · Rake, IABuilt 1976 · S/N 916-76 N300DCSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2003 · S/N 2842180 N300EFMrr LLC · Schererville, INBuilt 1977 · S/N 28-7715267 N300JFKempf Chris J · Kenai, AKBuilt 1977 · S/N 18-7709136 N300JLKehoe Keith J · Marion, TXBuilt 1966 · S/N MB-134 N300LCRobinson Russell J · Bridgeport, TXBuilt 1973 · S/N 17261520 N300PSRight Coast Ventures LLC · Royse City, TXBuilt 1968 · S/N 17257501 N300QRPdq Flight Inc · Garden City, NYBuilt 1979 · S/N 17273539 N300RGRein Richard C · St George, UTS/N AA5A-0159 N300WYChupka William J · Riverton, WYBuilt 1965 · S/N 28-21280 N30101Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 44-7995069 N3010ELenzen Richard D Dr · Antioch, ILBuilt 1978 · S/N 28-7916167 N3010WSunwest Aviation Inc · Santa Ynez, CABuilt 1995 · S/N 28-43016 N3010ZClemente Matthew J · Troy, NYBuilt 1959 · S/N 22-6961 N30112Leonard Kevin J · Wagner, SDBuilt 1968 · S/N 17701066 N30114International Aviation Group LLC · Lake Wales, FLBuilt 1978 · S/N 28-7916076 N30116Registration Pending · Benson, AZRegistration pendingBuilt 1968 · S/N 17701068 N30117D & S Aviation LLC · Spring, TXBuilt 1978 · S/N 28-7916077 N3011FGordon Air Services Inc · Miami, FLBuilt 1974 · S/N 17263447 N3011WHall Larry C · Decatur, ALBuilt 1996 · S/N 28-43065 N3011ZBoe Arvid J · Langdon, NDBuilt 1979 · S/N 28-7916393 N30126Pilots Choice Aviation Equipment Leasing Co · Georgetown, TXBuilt 1978 · S/N 28-7990084 N30128Mizani Air LLC · San Antonio, TXBuilt 1968 · S/N 17701069 N3012ABottoms Engineering & Service Inc · Frankfort, KYBuilt 1978 · S/N 28-7990112 N3012DArias Herman R · Waco, GAS/N 28-7916154 N3012EDamschroder Rex A · Fremont, OHBuilt 1978 · S/N 17271402 N3012ZChase 13 LLC · Wilmington, DEBuilt 1959 · S/N 22-6963 N30133Ts Fliers LLC · Mount Pleasant, MIBuilt 1968 · S/N 17701070 N30139Heinitz Bradford C · Arlington, WAS/N 17701074

Back to AD 79-10-03 R2