Registered aircraft · 40,473

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:80-04-03-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2') 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:80-04-03-R2')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
  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:80-04-03-R2')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:80-04-03-R2')
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.

N5509FAhs Aero LLC · Leo, INS/N 28-24850 N5509JJet Air Inc · Iowa City, IABuilt 1980 · S/N 17273810 N5509QCarlson Jeremy Nathaniel · Arnold, CABuilt 1965 · S/N 2943 N5509WKitts John L · New Braunfels, TXBuilt 1962 · S/N 28-597 N550DEJanay Jesse A · Charlottesville, VABuilt 1998 · S/N 2656 N550FLKennedy Adam B · Des Moines, WAS/N 28-7125387 N550PEHeller Ross S · Gig Harbor, WAS/N 550 N550PUSkyborne Airline Academy Inc · Vero Beach, FLBuilt 2000 · S/N 2842106 N5510FHughes Arlen L · Saratoga, WYBuilt 1968 · S/N 28-24851 N5510WMilius Douglas L · Oshkosh, WIBuilt 1962 · S/N 28-598 N55115Gleason Ronald L · Willows, CAS/N 28-7305313 N5511FSmith Jimmy A Jr · Albemarle, NCBuilt 1968 · S/N 28-24852 N5511PGear Down Hangar LLC · Phoenix, AZBuilt 1958 · S/N 24-574 N5511QJohnston Evan · Yakima, WABuilt 1965 · S/N 2944 N55121Lifetime Adventures LLC · Bellevue, MIBuilt 1981 · S/N 17275114 N55124Stroud Stephen D · Independence, MOS/N 28-7325329 N55126Zing Aviation And Marine LLC · New Smyrna Beach, FLFirst renewal noticeBuilt 1981 · S/N 17275116 N55127Lands James M · Stoutsville, OHBuilt 1973 · S/N 28-7305314 N55129Bauer Roger · Saint Germain, WIBuilt 1973 · S/N 28-7305319 N5512EMorcom Aviation Services Inc DBA · Everett, WABuilt 1978 · S/N 17271881 N5512FWestergaard Wayne B · Craig, NEBuilt 1968 · S/N 28-24854 N5512URegistration Pending · Smiths Station, ALRegistration pendingBuilt 1969 · S/N 28-26223 N5512VCabaniss Tex P Jr · Cypress, TXBuilt 1977 · S/N 28-7725240 N5512WMoy Jack M · Los Angeles, CABuilt 1962 · S/N 28-600 N5512ZShadow Aviation Inc · Fairbanks, AKBuilt 1964 · S/N 18-7845 N55135Air Ventures Flying School LLC · Smithfield, RIBuilt 1973 · S/N 28-7325331 N55136Alberio Angela E · Bloomington, MNBuilt 1973 · S/N 28-7325332 N55139Hanson Mark A · Snelling, CABuilt 1973 · S/N 28-7305320 N5513UShi Yi · Walnut, CABuilt 1969 · S/N 28-26225 N5513WJohnson Thomas D · Pilot Mountain, NCBuilt 1962 · S/N 28-601 N55140Di Giorgio Thomas J Jr · Lopez Island, WABuilt 1973 · S/N 28-7305321 N55144Bell Air LLC · Las Cruces, NMBuilt 1981 · S/N 17275118 N55146Sky High Aviation LLC · Gonzales, LABuilt 1981 · S/N 17275119 N55148Lierle Sidney D · Clearlake, CABuilt 1973 · S/N 28-7325333 N55149County 17 Aviators LLC · Gillette, WYS/N 28-7325334 N5514FWingrove Rodney W · Vincent, OHBuilt 1968 · S/N 28-24856 N5514MPruitt Buster Jr · Shelbyville, TNBuilt 1967 · S/N 113 N5514PCohran Enterprise LLC · Pineville, LABuilt 1958 · S/N 24-577 N5514UCheckers Investments Inc · Edmond, OKBuilt 1969 · S/N 28-26226 N55150Alexander Dennis K · Gallatin, TNBuilt 1973 · S/N 28-7305322 N55151Learn 2 Fly LLC · Cantonment, FLBuilt 1973 · S/N 28-7415001 N5515MBarringer William R · Benbrook, TXBuilt 1967 · S/N 140 N5515SGotay Ricardo M · Watertown, CTBuilt 2003 · S/N 33004C N55160Davis Joseph S · Andalusia, ALBuilt 1981 · S/N 17275123 N55163Jackson Donald W · Carthage, MSBuilt 1973 · S/N 28-7325335 N55166Volando LLC · Columbia, MOBuilt 1973 · S/N 28-7325338 N55167Flyboys Nevada LLC · Henderson, NVBuilt 1973 · S/N 28-7305325 N55169Jin Jin Aviation LLC · Anchorage, AKBuilt 1981 · S/N 17275126 N5516FMoore Marcus · Auburn, ALS/N 28-24858 N5516UHicks David A · Beaver Dam, WIBuilt 1969 · S/N 28-26228

Back to AD 80-04-03 R2