Skip to content

Registered aircraft · 5,086

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:91-21-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:91-21-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:91-21-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:91-21-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:91-21-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:91-21-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.

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 N553TCHawksley LLC · Bozeman, MTBuilt 2004 · S/N T20608487 N5543SCascade Marine Holdings Inc · Terrebonne, ORBuilt 1978 · S/N 32R-7887031 N5545YKolarek Frank · West Nyack, NYFirst renewal noticeBuilt 1964 · S/N 27-2644 N554KDWestern Air International Co · Pompano Beach, FLBuilt 1979 · S/N 31-7952157 N55510Western Community College Area DBA · Scottsbluff, NES/N 1252 N555BPBayusik Kevin R · Shelton, CTBuilt 1980 · S/N 32R-8029072 N555BWZia Air LLC · Hagerman, NMBuilt 1974 · S/N 61P-0168-007 N555FSJacko Josh E · Anchorage, AKBuilt 1978 · S/N 31-7952046 N555GTRegistered aircraftBuilt 1979 · S/N 31-7952148 N555HRJtu Aviation LLC · Laramie, WYBuilt 2005 · S/N 27-0333 N555JGLeia Air LLC · Wilmington, DEBuilt 1979 · S/N 31-8012018 N555JVColumbia Recreation LLC · Quincy, WABuilt 2000 · S/N 4636270 N555MFCloud 555 Inc · Wilmington, DEBuilt 1980 · S/N 31-8012068

Back to AD 91-21-01 R1