Registered aircraft · 20,483

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:84-10-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1') 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:84-10-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
  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:84-10-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-10-01-R1')
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.

N205BBHixon George S · San Antonio, TXBuilt 1962 · S/N 205-0060 N205BPRegistered aircraftBuilt 1962 · S/N 205-0089 N205CLFreedenberg Philip J · Canton, CTBuilt 1963 · S/N 205-0452 N205CRRlh Montana LLC · Helena, MTBuilt 1963 · S/N 205-0286 N205CTBas Part Sales LLC · Greeley, COS/N 205-0226 N205FBennett James G · Erie, COBuilt 1964 · S/N 205-0573 N205FJPilots Nw Inc · Bellingham, WABuilt 1962 · S/N 205-0050 N205HNTischer Jesse · Des Moines, IABuilt 1963 · S/N 205-0440 N205JNHand Patrick · Cape Charles, VABuilt 1967 · S/N 18258437 N205LSky King Airplanes LLC · Lewes, DEBuilt 1963 · S/N 205-0329 N205NBAirmotive Service LLC · Brigham City, UTBuilt 1962 · S/N 205-0151 N205NDThompson Shane E · Warroad, MNBuilt 1966 · S/N 18051744 N205RTTriple D Cessna LLC · Greenville, SCBuilt 1962 · S/N 205-0014 N20605Registration Pending · Escondido, CARegistration pendingBuilt 1981 · S/N 18053199 N2060GPrince William R · Murrieta, CABuilt 1958 · S/N 51360 N2061BM R O Drug Test Results LLC · Wintersville, OHBuilt 2003 · S/N 20608200 N2061MN2061m LLC · Augusta, GABuilt 2026 · S/N 18283337 N2063JWest Aviation Inc · Creston, IABuilt 1978 · S/N T18803353T N2063PRegistered aircraftBuilt 2005 · S/N 18281644 N20640Cahoon Neil T · Camas, WABuilt 1981 · S/N 18053202 N2064GGarcia Edward O · Hereford, AZBuilt 1958 · S/N 51364 N2064XCurtin Andrew J · Fernandina Beach, FLBuilt 1965 · S/N 18256164 N2065GZach Matthew L · Oconomowoc, WIBuilt 1958 · S/N 51365 N2066GLatofski-Jeffries Gustavo Enrique · Mcallen, TXBuilt 1958 · S/N 51366 N2066JKlein Flying Service Inc · Lawrenceville, ILBuilt 1978 · S/N T18803356T N2067GYeager Hal J · Winterset, IAS/N 51367 N2067XPank Thomas E · Walkersville, MDBuilt 1965 · S/N 18256167 N2068RSix Lima Papa LLC · Kalispell, MTS/N 18255268 N2069RLazy T Aviation LLC · Ashland, NES/N 18255269 N2069XFrance Frederick M · Gales Ferry, CTBuilt 1965 · S/N 18256169 N206ARCanoe Bay Outfitters LLC · Port Alsworth, AKBuilt 1978 · S/N U20604766 N206AYOno Yutaka · Torrance, CABuilt 1967 · S/N U206-0820 N206BABoeing Company · Mesaon, AZBuilt 1973 · S/N U20602034 N206BCSkelton Thomas N · Madison, MSBuilt 1999 · S/N 20608025 N206BLWright Kim B · Anchorage, AKBuilt 1979 · S/N U20605491 N206BRWest Matthew Shawn · Island, KYBuilt 1981 · S/N U20606350 N206BSBlue Star Gas Fleet Services Co · Central Point, ORBuilt 1968 · S/N P206-0434 N206CGSmalley Glen E · Kasilof, AKS/N P206-0136 N206CPCivil Air Patrol · Maxwell Afb, ALBuilt 2005 · S/N 20608227 N206CTDe Creeft Joseph M · Homer, AKBuilt 1981 · S/N U206-06090 N206DP W Feenstra Construction Inc · Queen Creek, AZBuilt 1978 · S/N U20604415 N206DCAri Air LLC · Anchorage, AKBuilt 1976 · S/N U20603198 N206DJAlum I Tank Inc · Harvard, ILBuilt 1963 · S/N 206-0055 N206DMBushwood Air LLC · Coeur D Alene, IDBuilt 1976 · S/N U20603512 N206DZEvans David J · Parker, COS/N 206-0185 N206EJSzymanski Collin Andrew Sr · Anchorage, AKBuilt 1974 · S/N U20602507 N206EKKoch & Koch Inc · Grass Valley, CABuilt 1981 · S/N U20606291 N206ELAir Tuna LLC · Homestead, FLS/N U20604037 N206EZHottois Scott · Whittemore, MIBuilt 1964 · S/N 2060048 N206FMoreau Aviation LLC · Wasilla, AKBuilt 1975 · S/N U20603015

Back to AD 84-10-01 R1