Skip to content

Registered aircraft · 6,916

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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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:71-13-01-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.

N54236B & R Aircraft LLC · Wadsworth, OHBuilt 1974 · S/N 27-7554030 N54238Backcreek Farms Inc · Rougemont, NCBuilt 1974 · S/N 27-7554032 N54240Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554034 N54245Pacific Fleet Aviation LLC · Rochester, NYBuilt 1974 · S/N 27-7554039 N5424CBello Aviation LLC · Naples, FLFirst renewal noticeS/N T20608494 N5424DCarpenter Michael H · Mooresville, NCS/N 20028 N54258Nesbeda Peter J · Marlborough, NHBuilt 1974 · S/N 27-7554046 N542CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N T18209033 N543133seaslal LLC · Lakeland, FLBuilt 1974 · S/N 31-7405439 N5431FSea Container Sales Inc · New Waverly, TXBuilt 1976 · S/N 32-7740004 N5431YThompson Sherrel L · Pembroke Pines, FLBuilt 1964 · S/N 27-2508 N5432FHornish Thomas L · Malinta, OHBuilt 1976 · S/N 32R-7780007 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 N544KGDawson Aircraft Inc · Clinton, ARS/N T18209006 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 N545RSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 4636668 N54621Atlantic Resources Of Miami Inc · Deland, FLS/N 27-7554036 N546CPiper Aircraft Inc · Vero Beach, FLBuilt 2026 · S/N 4636879 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 N549BJN549bj LLC · Fayetteville, ARBuilt 2022 · S/N T20609688 N549JBBlue Bird Aviation LLC · Ocean City, MDBuilt 1980 · S/N 31-8052108 N549RJCynergy Cargo LLC · Douglas, GABuilt 2008 · S/N 4692099 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 N54CLAir Transport Resources · Naperville, ILBuilt 1970 · S/N 31-652

Back to AD 71-13-01 R1