Registered aircraft · 40,471

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.

N9773BChagres Flight Training LLC · Albuquerque, NMBuilt 1981 · S/N 172RG1027 N9773J1st Flight LLC · Granby, COBuilt 1967 · S/N 28-3972 N9773UEnos Matthew · Jackson, MOBuilt 1976 · S/N AA5A0173 N97749Beck Shylan · Blanding, UTBuilt 1984 · S/N 17276225 N9774DRegistration Pending · Wolf Point, MTRegistration pendingBuilt 1959 · S/N 18-6835 N9774WAmerican Patrols Inc · Midland, TXBuilt 1974 · S/N 17264500 N97755Civil Air Patrol Inc · Maxwell Afb, ALBuilt 1984 · S/N 17276226 N9775BAequalis Photography Corp · Tacoma, WAFirst renewal noticeBuilt 1981 · S/N 172RG1029 N9775LLassiter Jason T DBA · Ephrata, PABuilt 1972 · S/N M-1391 N97766Wiggins Air Patrol LLC · Wichita, KSBuilt 1984 · S/N 17276228 N9776D76 Delta LLC · Garwood, TXBuilt 1959 · S/N 18-6837 N9776JVarman Michael J · Elwood, ILS/N 28-3975 N9776UMurphy James J · Winston Salem, NCBuilt 1976 · S/N AA5A-0176 N97779Kool Wings Leasing LLC · Indianapolis, INBuilt 1984 · S/N 17276230 N9777DRouse Kenneth L Jr · Joseph, ORBuilt 1957 · S/N 18-6191 N9777JKunick Matthew · Belfair, WAS/N 28-3976 N9777LEarl W Morrow Cpa Pe · Williamson, GAFirst renewal noticeBuilt 1972 · S/N M-1392 N9777UFlippo Pete · Meeker, OKBuilt 1976 · S/N AA5A-0177 N9777WWinthrop Michael F · Gainesville, VABuilt 1967 · S/N 28-23265 N97789Delta State University · Cleveland, MSBuilt 1984 · S/N 17276231 N9778JGilroy Shawn J · Bremen, GABuilt 1967 · S/N 28-3977 N9779VCoombs Eric S · Louisburg, NCBuilt 1974 · S/N 17264501 N9779WNovember Sierra Aviation LLC · Oneill, NES/N 28-23267 N977ACNaples Air Center Inc · Naples, FLBuilt 1988 · S/N 2816073 N977JOklahoma Aeronautics Academy LLC · Oklahoma City, OKBuilt 1976 · S/N 28-7715198 N977JTCrivellari Marco · Virginia Beach, VABuilt 2002 · S/N 977 N977KJFalcon Aviation Inc · Southfield, MIS/N 17261987 N977MASnodgrass James T · Gallipolis, OHBuilt 1980 · S/N 28-8116032 N977PAGlobal Aviation Corp · Farmingdale, NYBuilt 1979 · S/N ME-195 N977PMFlamoil Wings LLC · Kaiser, MOBuilt 1981 · S/N 44-8107040 N977SQFrech Egon Trustee · Lexington Park, MDBuilt 1979 · S/N 17272303 N977VMVan Hatten Michael Sr · Fairbanks, AKBuilt 1953 · S/N 18-2839 N9780DTubreaux Aviation Services LLC · Shreveport, LABuilt 1959 · S/N 18-6849 N9780J824-24th St LLC · Greeley, COBuilt 1967 · S/N 28-3979 N9780URichmond Airport Inc · West Kingston, RIBuilt 1976 · S/N AA5A-0180 N9780WRosales Daniel M · Fairbanks, AKBuilt 1967 · S/N 28-23269 N97811Angel Aviation Inc · Peoria, AZBuilt 1984 · S/N 17276232 N9781JWild Wingdom LLC · Greenville, SCBuilt 1967 · S/N 28-3982 N9782CTranel Aviation LLC · Port Edwards, WIBuilt 1978 · S/N 28-7890443 N9782LConnolly David · Austin, TXBuilt 1972 · S/N M-1393 N9782VOn Glideslope LLC · Middletown, DEFirst renewal noticeBuilt 1974 · S/N 17264502 N9782WWolfehagen Paul B · Phoenix, AZS/N 28-23271 N9783DBulawa Austin R · Wasilla, AKBuilt 1959 · S/N 18-6853 N9783LBeck Joseph P III · Pollock, LABuilt 1972 · S/N M-1394 N9783PKent State University · Stow, OHBuilt 1984 · S/N 17276234 N9784BRecycleworx LLC · Sun City, AZBuilt 1981 · S/N 172RG1034 N9784JScott Richard · Hagaman, NYBuilt 1967 · S/N 28-3965 N9785JWells Legacy Consultants LLC · Hickory Creek, TXBuilt 1967 · S/N 28-3986 N9785WLattaye Silas F · Mamou, LAS/N 28-23275 N9786LPerun Av LLC · Cliffside Park, NJBuilt 1986 · S/N 17276612

Back to AD 80-04-03 R2