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.

N40200Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1973 · S/N 27-7304997 N40254Jezior Michael · Midland, MIBuilt 1973 · S/N 27-7305061 N40267Island Birds Inc · St Thomas, VIBuilt 1973 · S/N 27-7305080 N40279Hhozapnv LLC · Las Vegas, NVBuilt 1973 · S/N 27-7305093 N40288Pacific Fleet Aviation LLC · Rochester, NYBuilt 1973 · S/N 27-7305104 N40372Gajewski Lillia M · Billings, MTBuilt 1973 · S/N 27-7305135 N40399Aviation Academy LLC · Wichita, KSBuilt 1973 · S/N 27-7305163 N40400R & P Aero LLC · Grand Haven, MIBuilt 1973 · S/N 27-7305164 N40453Aerospace Trust Management LLC Trustee · Wilmington, DES/N 27-7305166 N40454Bas Part Sales LLC · Greeley, COBuilt 1973 · S/N 27-7305167 N40464Pavco Inc · Gig Harbor, WABuilt 1973 · S/N 27-7305181 N40465Bartow Municipal Airport Development Authority · Bartow, FLBuilt 1973 · S/N 27-7305182 N40471Hamilton Christopher C · Sonoita, AZBuilt 1973 · S/N 27-7305189 N404CHNorthwestern Michigan College · Traverse City, MIBuilt 1976 · S/N 27-7654191 N40510Yonika Richard J · Northbridge, MABuilt 1973 · S/N 27-7405241 N40522Khag Aviation Inc · Woodbridge, NJFirst renewal noticeBuilt 1973 · S/N 27-7405255 N40557Legacy Aviation LLC · Tea, SDBuilt 1973 · S/N 27-7405297 N40559Frost Aviation Services Inc · Las Cruces, NMBuilt 1973 · S/N 27-7405300 N40566Miller Stan · Skiatook, OKBuilt 1973 · S/N 27-7305188 N40569Harvey Sawyer N · Jaffrey, NHBuilt 1974 · S/N 27-7405310 N40571Bwh Leasing LLC · Lewes, DEBuilt 1974 · S/N 27-7405313 N40578Dna Flight Ops LLC · Edgewater, FLBuilt 1974 · S/N 27-7405322 N40581Chagres Aero LLC · Albuquerque, NMBuilt 1974 · S/N 27-7405325 N40588Csc Delaware Trust Co Trustee · Wilmington, DEBuilt 1974 · S/N 27-7405332 N40592Rml Aircraft Inc · Staunton, VABuilt 1974 · S/N 27-7405337 N40599Tcb Aviation Inc · Knoxville, TNBuilt 1974 · S/N 27-7405345 N4060LBentley Aviation Services LLC · Lewes, DEBuilt 1966 · S/N 27-3324 N40LWMorgan Aviation LLC · Oak Harbor, WABuilt 1975 · S/N 27-7554146 N4109AMarc Inc · Bolton, MSBuilt 1970 · S/N 27-4459 N410RABradley Aviation Group LLC · Van Nuys, CABuilt 1979 · S/N 27-7954097 N412LClark Terry E · Dixon, MOBuilt 1954 · S/N 23-18 N415CCCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1968 · S/N 27-3908 N415MDHammychan Industries LLC · Glendale, AZBuilt 1967 · S/N 27-3492 N416GSB & K Travel LLC · Wilmington, DEBuilt 1975 · S/N 27-7554094 N417GTLs Aerospace Inc · Big Spring, TXBuilt 1974 · S/N 27-7405467 N42050Baum Thomas J · Kaufman, TXBuilt 1969 · S/N 27-4081 N4252UDoitch Dan · Parowan, UTS/N 27-465 N429HPJohn Allen Construction LLC · Big Sandy, TNBuilt 1971 · S/N 274695 N4321YSchuermann Chris L · Sand Springs, OKBuilt 1965 · S/N 27-607 N4322TKing Kong Broadcasting Inc · Las Vegas, NVBuilt 1964 · S/N 27-2524 N4329YDetert Bradley · Valparaiso, INBuilt 1966 · S/N 27-619 N43838Rodelsperger Robert · Charleston, SCS/N 27-4334 N43CCWpb Pilot Service LLC · West Palm Beach, FLBuilt 1965 · S/N 27-2820 N43HBConefry Michael A · Belle Chasse, LABuilt 1974 · S/N 27-7405379 N43PTOso Air LLC · Missoula, MTS/N 27-7305217 N4426YR & S Enterprises · Fort Wayne, INBuilt 1971 · S/N 27-4708 N444JKHodges Aviation LLC · Cleburne, TXBuilt 1977 · S/N 27-7854025 N444VMPrecise Flights LLC · Jensen Beach, FLBuilt 1974 · S/N 27-7405320 N447TThompson Systems Inc · Amana, IABuilt 1969 · S/N 27-4288 N44FDHildreth David M · Kennesaw, GABuilt 1956 · S/N 23-500

Back to AD 81-04-05 R1