Registered aircraft · 25,370

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-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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:80-25-07-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.

N5102ECag Aircraft Holdings LLC · Crystal River, FLBuilt 1978 · S/N 17271714 N5102TPettis Aviation LLC · Atlantic, IABuilt 1966 · S/N 72 N5102URegistered aircraftBuilt 1979 · S/N 172RG0236 N5103TReace Enterprises LLC · Woodbury, MNBuilt 1966 · S/N 441 N5103UMontana Aircraft Trust Inc Trustee · Bozeman, MTBuilt 1980 · S/N 172RG0237 N5103XPlane And Simple LLC · Lakewood, COBuilt 1969 · S/N 166 N5104TConsolidated Aviation Services LLC · Seymour, TNBuilt 1966 · S/N 496 N5105MAscend Aviation LLC · Bountiful, UTBuilt 1980 · S/N 15284499 N5105PJet & Rotor Aviation LLC · Sacramento, CABuilt 1981 · S/N 15284877 N5105QBailey Glenn E · Oldenburg, INBuilt 1973 · S/N 17261749 N5105TRider Charles A · Kokomo, INBuilt 1966 · S/N 502 N5105XManairco Inc · Wooster, OHBuilt 1969 · S/N 150 N5105YMcduff Douglas M · Cook, MNBuilt 1980 · S/N 21064074 N5106BBabcock Lori A · Salina, KSBuilt 1979 · S/N 15283747 N5106CQuest Aviation Inc · Lake City, FLBuilt 1979 · S/N 21063704 N5106SDawson Michael · Lynnwood, WAS/N R18201505 N51070Rabbit Hill Industries Inc · Bedford, NYS/N 17274262 N5107BWest Valley Flying Club · Palo Alto, CABuilt 1979 · S/N 15283748 N5107CDalrymple Michael J · San Luis Obispo, CABuilt 1979 · S/N 21063705 N5107HFlyit LLC · Camas, WABuilt 1975 · S/N 17265342 N5107WRugger Investment Group LLC · Sheridan, WYBuilt 1981 · S/N P21000640 N51081N51081 LLC · Palm City, FLS/N 17274264 N5108JHembree Ricky · Rockwall, TXBuilt 1980 · S/N 17273705 N5108LHellix LLC · Charlotte, NCS/N 15284266 N51092Sylvania Airport LLC · Sturtevant, WIS/N 17274265 N5109BOverlander Aviation LLC · Palo Alto, CABuilt 1979 · S/N 15283750 N5109XHarkema James P · Troy, OHBuilt 1969 · S/N 663 N510AASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1982 · S/N 21064699 N510FAEndeavour Flight Training Inc · Opa Locka, FLBuilt 1976 · S/N 17268470 N510LSRegistration Pending · Nashville, TNRegistration pendingBuilt 2002 · S/N 899-2002 N510WFFuel Center Plus Inc · Silver City, NMBuilt 1980 · S/N 21064140 N51109Dickhaut Olivia N · North Palm Beach, FLS/N 17274268 N5110XT & M Aerial Spraying · Garland, NCBuilt 1969 · S/N 192 N5111XJeter Michael C · Jacksboro, TXBuilt 1969 · S/N 664 N5112TStevens Richard N · Venice Center, NYBuilt 1966 · S/N 534 N5113KParrillo Development And Real Estate LLC · Sarasota, FLBuilt 1979 · S/N 17272455 N5113QTri-County Aviation LLC · Lawrenceburg, TNS/N 17261754 N5113TSchaffner David A · Wray, COBuilt 1966 · S/N 516 N5113XHemstock Ronn · Seward, AKBuilt 1969 · S/N 666 N5114KParrillo Development And Real Estate LLC · Moorestown, NJBuilt 1980 · S/N 17273974 N5114THarlan Robert J · Kaycee, WYS/N 71 N5114USilverhawk Aviation Academy LLC · Caldwell, IDBuilt 1980 · S/N 172RG0243 N5115EBarak David T · Mountain Home, IDBuilt 1978 · S/N 17271717 N5115TTurkey Creek Aviation And Helicopter Service LLC · Uvalde, TXBuilt 1966 · S/N 137 N5115XArbaczauskas Stanislaus · Daphne, ALBuilt 1969 · S/N 167 N5116JCarll Elizabeth M · Chicago, ILBuilt 1979 · S/N 17273707 N5116QAvolant Aviation LLC · Mooresville, NCBuilt 1981 · S/N 15285078 N51178Tussey Mountain Flying Club LLC · State College, PABuilt 1980 · S/N 17274274 N5117EJav Air Services LLC · Anchorage, AKBuilt 1978 · S/N 17271719 N5117QBush Thomas D Jr · Cypress, TXS/N 17261755

Back to AD 80-25-07 R1