Registered aircraft · 5,075

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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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:84-19-03-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.

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 N555PRHarlan Thomas D · Fresno, CABuilt 1969 · S/N 27-4248 N555RUHands Holding · Newark, DEBuilt 1981 · S/N 32R-8129114 N555SSSkylink Group LLC · York, PABuilt 1976 · S/N 14045 N555TPNugget Investments LLC · Strongsville, OHBuilt 1979 · S/N 32R-8029041 N555UWMcdaniel John D Jr · Leesburg, GABuilt 1978 · S/N 32R-7887117

Back to AD 84-19-03 R1