Registered aircraft · 8,921

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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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:85-02-05-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.

N2235WSamuels Walter E · Wilmington, NCBuilt 1969 · S/N 30-1844 N2236PCitation X Parts LLC · Liberty, NCBuilt 1956 · S/N 23-845 N2239AGoring Hugh W · Rimrock, AZBuilt 1952 · S/N 22-635 N2239PCumbee Danny A · Geneva, ALS/N 23-848 N223DAAerodrome LLC · Louisville, KYBuilt 1970 · S/N 27-4563 N2240PAnderson Timothy H · Janesville, WIBuilt 1956 · S/N 23-849 N2242UAir-Mods Flight Academy Inc · Robbinsville, NJBuilt 1979 · S/N 44-7995259 N2243AWilson Edward M · Urbandale, IABuilt 1952 · S/N 22-646 N2244PIsland Birds Inc · St Thomas, VIFirst renewal noticeS/N 27-7405256 N2246ABent James L Jr · Palatine Bridge, NYS/N 20-906 N2247BD & L Aircraft Leasing LLC · Ormond Beach, FLBuilt 1978 · S/N 44-7995108 N224KJam Three LLC · St George, UTBuilt 1959 · S/N 24-1609 N224TPSale Reported · Carson City, NVSale reported, pending cancellationBuilt 1955 · S/N 22-2950 N2250ASteele Matthew L · Saint Croix Falls, WIBuilt 1952 · S/N 22-652 N2254AGarrett William H · West Des Moines, IABuilt 1952 · S/N 20-908 N2254PTamayo Alejandro S · San Luis, AZBuilt 1957 · S/N 23-864 N2255YShogren Scott F · Fort Pierce, FLFirst renewal noticeS/N 30-1268 N2258AGraham Steven K · Mc Grath, AKBuilt 1952 · S/N 20-909 N225ABMinden Soaring Club Inc · Minden, NVBuilt 1967 · S/N 25-4236 N225HMSmithart Eric W · San Juan, PRBuilt 1963 · S/N 27-2341 N2260PToliver David R · Overland Park, KSBuilt 1957 · S/N 23-870 N2268YMohr Marcia L DBA · New Richmond, WIBuilt 1964 · S/N 30-544 N226MAdams Larry Gene · Parker, AZBuilt 1960 · S/N 24-2326 N2271PHorton Christian J · Melbourne Beach, FLBuilt 1957 · S/N 23-881 N2272ARegistered aircraftBuilt 1952 · S/N 20-911 N2278AStafford David C · San Luis Obispo, CABuilt 1952 · S/N 22-665 N2279AScott Michael Sr · Kahoka, MOFirst renewal noticeBuilt 1952 · S/N 22-668 N227CARa Procurement LLC · Helena, MTS/N 27-4591 N227RGLearn To Fly In Central Arkansas LLC · Searcy, ARBuilt 1974 · S/N 27-7554021 N2282AGonsioroski Charles F · Baker, MTS/N 22-674 N2287P250 Flyers LLC · Middletown, DEBuilt 1957 · S/N 23-898 N2288PChisum Robert · Lorenzo, TXS/N 23-899 N2289ABauer Melchior E · Vallejo, CAS/N 22-677 N228FPRegistered aircraftS/N 24-2538 N2291PNice Flight LLC · Medford, ORBuilt 1957 · S/N 23-902 N2293PGaston Stephen · Saint James City, FLBuilt 1957 · S/N 23-905 N2294AWeber Jacob · Homer, AKBuilt 1952 · S/N 22-679 N2296PTarrant County College · Fort Worth, TXBuilt 1957 · S/N 23-908 N2299PMoeller Wendell L · Porter, TXBuilt 1957 · S/N 23-884 N229MKyzer Aviation Holdings LLC · Fort Mill, SCBuilt 1969 · S/N 27-4252 N229TYSchilling Aviation LLC · Britton, MIBuilt 1962 · S/N 24-3339 N22CJCleveland Adam · Abilene, TXBuilt 1965 · S/N 30-905 N22GNSkattum LLC · Sioux Falls, SDBuilt 1956 · S/N 22-3948 N22LMRd Aire LLC · Opelika, ALBuilt 1963 · S/N 30-56 N22SGAir Flight Enterprises Inc · South Daytona, FLS/N 30-1718 N22TKGreen Theodore G · Franklin, WIBuilt 1963 · S/N 24-3541 N22VTMcmath Robert Roy · Seeley Lake, MTBuilt 1977 · S/N 27-7754074 N22ZZTreicher Peter · East Aurora, NYFirst renewal noticeBuilt 1979 · S/N 27-7954043 N2300ACooper Brian T · Chandler, AZBuilt 1952 · S/N 22-687 N2301PWheatley David L · Saltsburg, PABuilt 1955 · S/N 22-2711

Back to AD 85-02-05 R1