Registered aircraft · 40,396

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.

N53351Clover Park Technical College · Lakewood, WABuilt 1981 · S/N 17274725 N5335DPeltz Matthew J · Ringsted, IABuilt 1979 · S/N 17272524 N5335FEasterby Daniel · Big Bear Lake, CABuilt 1976 · S/N 28-7790090 N5335WPost 8 Flight Ops Inc · Topeka, KSBuilt 1962 · S/N 28-392 N53361Adb Aircraft LLC · Viera, FLBuilt 1981 · S/N 17274727 N5336DFerguson Bart M · Argyle, TXBuilt 1979 · S/N 17272525 N5336KSharpes Daniel G · Albuquerque, NMBuilt 1980 · S/N 17274069 N53371Glidewell Aviation Inc · Parkland, FLBuilt 1981 · S/N 17274733 N5337FIxi LLC · West Bloomfield, MIBuilt 1976 · S/N 28-7790092 N5337SAnn Arbor Flyers Inc · Ann Arbor, MIBuilt 2001 · S/N 2843479 N53387Reifsnyder Daniel S · Lewistown, PABuilt 1981 · S/N 17274738 N5338LHaynes Robert · Friendswood, TXBuilt 1968 · S/N 28-4643 N5338VMassie Patrick J · Friendswood, TXBuilt 1980 · S/N 172RG0509 N5339DTang Hong-Ming · San Dimas, CABuilt 1979 · S/N 17272528 N5339HBering Capital LLC · Anchorage, AKBuilt 1975 · S/N 17265407 N5339KNordell Kent D · Staples, MNBuilt 1980 · S/N 17274071 N5339LAlpcal Group LLC · Ventura, CABuilt 1968 · S/N 28-4644 N5339SGyorke George Jr · West Ossipee, NHBuilt 1970 · S/N 28-26932 N5339WSmith Mark R · Pompano Beach, FLS/N 28-397 N533FLLuvsflying Flight Training LLC · Staten Island, NYS/N 28-7125363 N533MSSchlamer Mark A · Campbellsport, WIBuilt 1978 · S/N VAC-115-78 N533SJLns LLC · Wichita, KSBuilt 1978 · S/N 17271533 N53402Anvab Inc DBA · Concord, NHBuilt 1981 · S/N 17274743 N5340LFalcon Flying Club Inc · Mesa, AZBuilt 1968 · S/N 28-4645 N5341FZhang Linjie · Peachtree City, GABuilt 1976 · S/N 28-7725044 N5341HHoffman Calhoun E · Barnwell, SCBuilt 1975 · S/N 17265408 N5341SRegistration Pending · Selma, TXRegistration pendingBuilt 1970 · S/N 28-26806 N5341ZAtp Aircraft 4 LLC · Wilmington, DEBuilt 2001 · S/N 4496107 N5342DCornell Timothy R · Hartland, WIS/N 17272531 N5342FClark Robert L · Shippensburg, PABuilt 1976 · S/N 28-7715102 N53437Vineyard Eddie E · Wapello, IABuilt 1981 · S/N 17274749 N5343FTrident Aircraft Leasing LLC · Easton, MDBuilt 1976 · S/N 28-7715103 N5344DAirgo Inc · Centralia, ILBuilt 1979 · S/N 17272532 N5344HA&F Aviation Services LLC · Collierville, TNBuilt 1975 · S/N 17265409 N5344KBoeing Employees Flying Assoc · Renton, WABuilt 1980 · S/N 17274074 N5344STop Flight Aviation Snh LLC · Savannah, TNBuilt 1970 · S/N 28-26812 N53456Amelia Reid Aviation LLC · San Jose, CABuilt 1981 · S/N 17274754 N5345FArcher Air LLC · Traverse City, MIBuilt 1976 · S/N 28-7790093 N5345WShisler Bill · Missoula, MTBuilt 1962 · S/N 28-404 N53463Fara Nick · San Anselmo, CABuilt 1981 · S/N 17274758 N5346DBoldflight LLC · Greenwood, INBuilt 1979 · S/N 17272534 N5346EOsprey Holding Company LLC · Foley, ALBuilt 1977 · S/N 17269573 N5346FSo Send I You LLC · Cheyenne, WYS/N 28-7790094 N5346KUsaeroflight LLC · Greenville, SCS/N 17274075 N5346UAverett University · Danville, VABuilt 2003 · S/N 2843542 N5346VRegistered aircraftBuilt 1980 · S/N 172RG0510 N5347HMonterey Bay Aviation Inc · Watsonville, CABuilt 1975 · S/N 17265410 N5347LKing Michael · Durango, COBuilt 1968 · S/N 28-4650 N5348DSwaz Aviation LLC · Mesa, AZBuilt 1979 · S/N 17272536 N5348LPn4 Aviation Holdings LLC · Bishop, CAS/N 28-4651

Back to AD 79-10-03 R2