Skip to content

Registered aircraft · 1,079

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:81-04-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:81-04-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:81-04-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:81-04-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:81-04-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:81-04-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.

N2323MPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954039 N2345RBlue Wave Air LLC · Huntsville, ALBuilt 1981 · S/N 27-8154019 N2352ZPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-8054022 N235DAMarc Aircraft Holding LLC · Soldotna, AKS/N 27-582 N235JKDetert Bradley · Valparaiso, INBuilt 1963 · S/N 27-587 N2367ZBrookie Aircraft LLC · Methuen, MABuilt 1979 · S/N 27-8054027 N2377ZMatthews Grover C · Hardinsburg, KYBuilt 1979 · S/N 27-7954116 N2380ZCopeland Medical LLC · Jonesboro, ARBuilt 1979 · S/N 27-8054031 N23ASRusso James F · Liberty, SCS/N 27-3094 N23AVJtz Aviation LLC · Wilmington, DEBuilt 1981 · S/N 27-8154003 N23FAHayes David B · Betsy Layne, KYBuilt 1960 · S/N 27-52 N23TACor Yan · San Juan, PRBuilt 1978 · S/N 27-7854114 N23WBQualitair LLC Trustee · MichelstadtBuilt 1973 · S/N 27-7405281 N23WGSamson Ryan · Escondido, CABuilt 1963 · S/N 27-565 N2405MFree Flyers Avionics Inc · Kerkhoven, MNBuilt 1979 · S/N 27-7954049 N240JBMarking Kevin J · Omaha, NEBuilt 1978 · S/N 27-7854108 N2418VHart William Kirby · Springville, CABuilt 1960 · S/N 27-81 N241CFPalermo Michael S · Carter Lake, IABuilt 1957 · S/N 23-1160 N241PBTranstek International Inc · Deerfield, ILBuilt 1964 · S/N 27-2589 N241TNWilmoth Matthew L · Traverse City, MIBuilt 1979 · S/N 27-7954110 N2437MRock Full Gospel Church · Parkersburg, WVBuilt 1979 · S/N 27-7954058 N2441MBlackburn Alan Ryan II · Palm City, FLBuilt 1979 · S/N 27-7954059 N244RWeiser Inc · Minburn, IABuilt 1973 · S/N 27-7305025 N2454FOlson Donald C · Golovin, AKS/N 27-2666 N245AGMummey Jose Pablo · Everett, WAS/N 27-7305187 N248KCracker Aviation LLC · Jupiter, FLBuilt 1975 · S/N 27-7654004 N24YCBeauchene Air II LLC · Des Moines, IABuilt 1970 · S/N 27-4551 N2501MSchwietz Thomas E Jr · Strasburg, VAS/N 27-7954068 N250BDSalom Auguste G · Old Orchard Beach, MEBuilt 1965 · S/N 27-3082 N250FDTailwind Aviation Inc · Sault Sainte Marie, MIBuilt 1976 · S/N 27-7654148 N250RTMatthews Aviation LLC · Hardinsburg, KYBuilt 1971 · S/N 27-4681 N250TASunset Aviation LLC · Halifax, PABuilt 1974 · S/N 27-7405364 N2510MYonder Corp · Wilmington, DEBuilt 1979 · S/N 27-7954070 N2516ZBig Sea Enterprises Inc · Wilmington, DEBuilt 1980 · S/N 27-8054039 N251EARegistered aircraftBuilt 1969 · S/N 27-4238 N253AMiller Christopher T · Newnan, GABuilt 1956 · S/N 23-806 N2562MPacific Fleet Aviation LLC · Rochester, NYBuilt 1979 · S/N 27-7954078 N2568MDe La Cruz Ronaldo · Cape Coral, FLBuilt 1979 · S/N 27-7954079 N2582ZChandler Air Service Inc · Chandler, AZBuilt 1980 · S/N 27-8154004 N2593ZGuillen Gregorio J · Phillipsburg, NJS/N 27-8154007 N25FTPacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7754038 N25JFBuckingham James M · Palmer, AKBuilt 1968 · S/N 27-3903 N25PKPacific Fleet Aviation LLC · Rochester, NYBuilt 1977 · S/N 27-7754105 N2604ZBurgan Grover W · Jacksonville, FLBuilt 1981 · S/N 27-8154012 N2608ZKaufield John E · Garden Prairie, ILBuilt 1981 · S/N 27-8154015 N26FTDelaware Aircraft Trust LLC Trustee · New Castle, DES/N 27-7754059 N270GGSkylens LLC · Hammond, LABuilt 1975 · S/N 27-7554085 N270WMsc Services Inc · Hugo, OKS/N 27-2129 N272GBaudouin Dameries · Pagosa Springs, COS/N 27-4189 N273BTN273bt Air LLC · Sweetser, INBuilt 1979 · S/N 27-7954112

Back to AD 81-04-05 R1