Skip to content

Registered aircraft · 26,231

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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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:94-05-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.

N5243MStrahm Ralph E · Holtville, CABuilt 1947 · S/N 10543 N5244Ployhart Edwin J · Harwood, NDBuilt 1968 · S/N 861 N5247QCavu Pilot LLC · Powell, TNS/N 15073147 N5248QSmith Gary A · Ericson, NEBuilt 1972 · S/N 15073148 N5249F3 Mad Wives Aviation LLC · Claremont, MNBuilt 1965 · S/N 17253346 N5249QLarson Loren R · Omro, WIBuilt 1972 · S/N 15073149 N524AZAaron Charles I · Chatsworth, GABuilt 2021 · S/N 001 N524BEPhilipsen Ben · Colleyville, TXBuilt 1951 · S/N 18-1650 N5250QLegan Matthew · Franklin, INBuilt 1972 · S/N 15073150 N5259QFrantz David L · Murfreesboro, TNBuilt 1972 · S/N 15073159 N525MTUnger Keith A · Frazer, MTBuilt 1946 · S/N 18464 N525SHMcn Systems LLC · Mount Airy, MDBuilt 1965 · S/N 15062549 N525ZMMaba Aircraft Services Co · Vero Beach, FLS/N 56760 N5261FTopken William F · Fallon, NVS/N 17253375 N5263QZahn Jason L · Towner, NDBuilt 1965 · S/N 17253380 N5265QCohan John K · Marina, CABuilt 1972 · S/N 15073165 N5267FColeman Timothy James · Cornwall On Hudson, NYBuilt 1965 · S/N 17253390 N5267QGibson Aviation Services LLC · Hudson, WIBuilt 1972 · S/N 15073167 N5268FVincennes University · Indianapolis, INBuilt 1965 · S/N 17253391 N526NRRamirez-Pagan Abelardo · Copperas Cove, TXBuilt 1982 · S/N 1181 N5270QPitman Mark T · Princeton, MNBuilt 1972 · S/N 15073170 N5271MHarris Robert C Jr · San Diego, CABuilt 1947 · S/N 14089 N5271QBridges Paul J · Denton, TXBuilt 1972 · S/N 15073171 N5275QSkyfarmer LLC · Culleoka, TNBuilt 1972 · S/N 15073175 N5278QRegistration Pending · Madison, MSRegistration pending, canceledBuilt 1972 · S/N 15073178 N527AAlpha Romeo Aviation LLC · Phoenix, AZBuilt 1976 · S/N 15078287 N527ANDaisy Aviation LLC · Beavercreek, OHBuilt 1965 · S/N 17252779 N527EDDorr Eric J · Piseco, NYBuilt 1949 · S/N 6555 N527RDWeiland Keith E · Chandler, AZBuilt 2017 · S/N 001 N5281QHhd Aviation LLC · Hamilton, OHS/N 15073181 N5285QBartell Kevin W · Abbottstown, PABuilt 1972 · S/N 15073185 N5286QPasterski Mark F · Chicago, ILBuilt 1972 · S/N 15073186 N5287QRice James L · Mckinney, TXBuilt 1972 · S/N 15073187 N5288QErnie Hall Aviation Museum Inc · Warren, OHS/N 15073188 N5289QNielson Douglas W · East Troy, WIBuilt 1972 · S/N 15073189 N5289XSeacoast Antique Hangar LLC · Madbury, NHS/N 5233 N5290QSaso Jan D · Hughson, CABuilt 1972 · S/N 15073190 N5291QQuinn Robert J · Kelleys Island, OHBuilt 1972 · S/N 15073191 N5293QRoberts Jeffrey E · Wheeling, WVBuilt 1972 · S/N 15073193 N5296QSun Baron · Arcadia, CABuilt 1972 · S/N 15073196 N5297QFalmouth Aviation LLC · North Falmouth, MABuilt 1972 · S/N 15073197 N5298QKirsch Richard D · Lisbon, NDBuilt 1972 · S/N 15073198 N5299QJa Flight Services LLC · Sugar Grove, ILBuilt 1972 · S/N 15073199 N529GEEmerson Michael · Sioux Falls, SDBuilt 2010 · S/N 1224 N529LMcclain Donald H · Pasadena, TXBuilt 1946 · S/N 498 N529PLCoussens John P · Boise, IDBuilt 2008 · S/N CC11-00065 N52AMMarquardt Ashley F · Anchorage, AKS/N AM11-1 N52EZWarnock Tony J · Mobile, ALS/N 1819 N52JWoodworth Trent · Carson City, NVBuilt 1975 · S/N GH-200 N52LERovey Byron G · La Grande, ORBuilt 1952 · S/N 20458

Back to AD 94-05-05 R1