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.

N907KSKingsky Flight Academy LLC · Lakeland, FLBuilt 1977 · S/N 17268575 N907LEAll Her Fault LLC · Fairbanks, AKBuilt 2004 · S/N 3623 N907MWaitman Bradley J · Wasilla, AKBuilt 2020 · S/N 001 N907PSBrock W Walker · Charleston, SCBuilt 1966 · S/N 28-3762 N907RUBlahut Michael · Anchorage, AKBuilt 1950 · S/N 18-192 N907STState Of Alaska Department Of Public Safety · Anchorage, AKBuilt 1960 · S/N 18-7262 N907TWCarpenter Orin C II · Anchorage, AKBuilt 2023 · S/N 0001 N907UTClaus Paul E · Chitina, AKBuilt 1957 · S/N 18-5547 N907WAPea-Wayman Flight LLC · Daytona Beach, FLBuilt 1976 · S/N 17267907 N907WMSpano Darren M · Deville, LABuilt 1979 · S/N 18-8009038 N907XLLunenschloss Michael L · Anchor Point, AKBuilt 1976 · S/N 18-7609010 N9080DTrieber Steven M · Eastport, MEBuilt 1958 · S/N 18-6448 N9081HRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1975 · S/N 17265930 N9081JPerkins Jimmy Keith · Lonoke, ARBuilt 1966 · S/N 28-3118 N9081LReed William B Trustee · San Jose, CABuilt 1970 · S/N 224-70 N90829Leading Edge Aviation Consultants LLC · Windsor, CTBuilt 1985 · S/N 28-8690011 N9082DLeahy Garry E · Van Wert, IABuilt 1958 · S/N 18-6450 N90839White Jake W · San Antonio, TXS/N 101 N9083DSachs Randy S · S Huntington, NYBuilt 1986 · S/N 28-8690050 N9083KShuey Robert D III · Albertville, ALBuilt 1977 · S/N 28-7890174 N9084FIsland Bound LLC · Dunedin, FLBuilt 1980 · S/N 172RG0352 N9085JBligh Michelle C · Oceanside, CABuilt 1966 · S/N 28-3122 N9085KSale Reported · Grayling, MISale reportedBuilt 1977 · S/N 28-7890175 N9085LBlanton Jeffrey D · Valley Center, KSBuilt 1970 · S/N 226-70 N9086DDarrow John K · Soldotna, AKBuilt 1958 · S/N 18-6460 N9086JBrogan William J · Port Matilda, PABuilt 1966 · S/N 28-3123 N9086KMedia Stew LLC · Carson City, NVBuilt 1977 · S/N 28-7890176 N90874Myers Brian R · South Bend, INBuilt 1985 · S/N 28-8690014 N90878Schmoll Steven D · Zimmerman, MNBuilt 1974 · S/N 194H N9087DBolden Family Farms · Little Rock, ARBuilt 1986 · S/N 2816001 N9088DMetro Aircraft Co · Bloomington, MNBuilt 1986 · S/N 28-8616049 N9088JRiggins Ryan W · Durango, COBuilt 1966 · S/N 28-3126 N9089HDavis Joseph S · Andalusia, ALBuilt 1975 · S/N 17265936 N908AFRobinson Craig M · Colfax, CABuilt 1967 · S/N 28-23976 N908QCCook Hugh Q · Aurora, COBuilt 2020 · S/N 82854 N908TBushby Harvey M · Minooka, ILBuilt 2009 · S/N M-II-2418 N90908Charles Wilford W · Big Lake, AKBuilt 1981 · S/N 18-8109043 N9091DCanton Logan J · Petersburg, AKS/N 18-6469 N9091HCampbell Raymond · Box Elder, SDBuilt 1975 · S/N 17265937 N9091VScheutzow David P · Medina, OHBuilt 1968 · S/N 690008 N90922Blair Ernest J · St Thomas, NDBuilt 1981 · S/N 18-8109045 N90928Skunberg Leonard T · Salmon, IDS/N 253-73 N9092HWinemiller Stevie Dale · Swifton, ARBuilt 1975 · S/N 17265938 N9092JRegistered aircraftBuilt 1966 · S/N 28-3130 N9092VHogan Roger C · Virginia Beach, VABuilt 1969 · S/N 690004 N9092WLong Earl V III DBA · Wichita, KSBuilt 1997 · S/N 246 N90931Davies Donald K · Hastings, MNBuilt 1981 · S/N 18-8109048 N90932Hall Air Inc · Weiner, ARBuilt 1973 · S/N 432-73 N9093FArcher 93f LLC · Danvers, MABuilt 1986 · S/N 28-8690039 N9093JRichardson Harley T Jr · Mullins, SCS/N 28-3131

Back to AD 79-10-03 R2