Skip to content

Registered aircraft · 5,102

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-12-06-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-12-06-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-12-06-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-12-06-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-12-06-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-12-06-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.

N5433FNh86 Bumblebee LLC · Henniker, NHBuilt 1976 · S/N 32R-7780008 N543CBTwin Aviation LLC · Coushatta, LAS/N 500B1317 N543JCBritshaw LLC · Lansdale, PABuilt 1977 · S/N 31-7752103 N543SBBielder Street Aviation LLC · North Charleston, SCBuilt 1979 · S/N 31-7912034 N54417Moore Alan J · Hays, KSBuilt 1973 · S/N 32-7440052 N54429Dickinson Robert Trustee · Edmond, OKBuilt 1973 · S/N 32-7440053 N5442FMcclary James Emmett Jr · Athens, ALBuilt 1976 · S/N 32R-7780010 N5447YAnderson Michael W · Wayzata, MNBuilt 1964 · S/N 27-2528 N544PBPortland Patrol Inc · Lake Oswego, ORBuilt 2001 · S/N 3257238 N5451FVirginia Aviators LLC · Sterling, VABuilt 1976 · S/N 32R-7780011 N5454YMatthews Grover · Fairborn, OHBuilt 1964 · S/N 27-2539 N54621Atlantic Resources Of Miami Inc · Deland, FLS/N 27-7554036 N5470YWeber Mark J · Dalton, MABuilt 1964 · S/N 27-2560 N54772Watts John J · Murchison, TXBuilt 1975 · S/N 27-7554080 N54775Hankins Shannon G · Tulsa, OKBuilt 1975 · S/N 27-7554082 N54796Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554097 N54809Mgc LLC · Brandon, FLBuilt 1975 · S/N 27-7554108 N54810Pacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554109 N54811Simms Linda Ann Murray Trustee · Westminster, MDBuilt 1975 · S/N 27-7554110 N5482TDavis Thomas E · Wisconsin Rapids, WIBuilt 1982 · S/N R18201877 N54854Registration Pending · Saint Augustine, FLRegistration pendingBuilt 1975 · S/N 27-7554154 N54857Mach Tuck LLC · Daytona Beach, FLBuilt 1975 · S/N 27-7554157 N54858Advanced Aviation Group LLC · Frederick, MDBuilt 1975 · S/N 27-7554158 N54861Fly Car Aviation LLC · North Fort Myers, FLBuilt 1975 · S/N 27-7554159 N54862J&P Master Flooring Corp · Lauderdale Lakes, FLBuilt 1975 · S/N 27-7554161 N54870Senter Carl V · Coeymans, NYBuilt 1975 · S/N 27-7554165 N5494YSchildberg Gregory M · Casey, IABuilt 1964 · S/N 27-2587 N5495YBerman Samuel I · Minneapolis, MNBuilt 1964 · S/N 27-2588 N549JBBlue Bird Aviation LLC · Ocean City, MDBuilt 1980 · S/N 31-8052108 N54ALSouthshore Aviation LLC · Oklahoma City, OKBuilt 1976 · S/N 61P-0326-092 N54AWWilson Cecil P · Lithonia, GABuilt 1974 · S/N 27-7405392 N54BG54 Bravo Golf LLC · Austin, TXS/N 32R-7887079 N54MVNeil Anthony Foster Holdings LLC · Santa Rosa, CABuilt 1976 · S/N 27-7654043 N54SSNinja Turtle LLC · Fuquay Varina, NCBuilt 1978 · S/N 32R-7885254 N54STMac Air Aviation LLC · Xenia, OHBuilt 1974 · S/N 27-7405358 N54WAWright Air Service Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652067 N5502YCreative Strategies Inc · Grayson, KYBuilt 1964 · S/N 27-2596 N55050Newman Jeffrey M · Pauline, SCBuilt 1973 · S/N 32-7340097 N55089Zitren Frederick J · El Cajon, CABuilt 1973 · S/N 32-7340100 N5513NBig Blue Aviation LLC · Pinehurst, NCBuilt 1980 · S/N 18267764 N55159Rasmussen Paul H · Mitchell, SDBuilt 1973 · S/N 32-7340103 N551HPMotorcarlease USA Inc · Miami Beach, FLBuilt 2001 · S/N T20608286 N55209De Cuir Dennis W · Incline Village, NVBuilt 1973 · S/N 32-7340105 N552DCAki H Korhonen · Reno, NVBuilt 2004 · S/N 27-0329 N552JAAv8r Flying Club LLC · Warsaw, INBuilt 1967 · S/N 32-40147 N552MNMtc Air LLC · Blue Ridge, GABuilt 2005 · S/N 18281588 N5533YAce Tomato Co LLC · Daytona Beach, FLBuilt 1964 · S/N 27-2631 N55360Ball Duke Allen · Drakesville, IABuilt 1973 · S/N 32-7340113 N553CBravo Air LLC · Frisco, TXBuilt 1991 · S/N 270105 N553HCHotel Charlie LLC · Dallas, TXBuilt 2004 · S/N T18208287

Back to AD 81-12-06 R1