Registered aircraft · 25,369

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.

N7780GAero Quest LLC DBA · Olive Branch, MSBuilt 1970 · S/N 17259480 N7781GKelley Aircraft LLC · Weyers Cave, VABuilt 1970 · S/N 17259481 N7781MJamison Terry J · Fort Mcdowell, AZS/N 22-0029 N7782MEvans Richard C · Shepherd, MIBuilt 1974 · S/N 22-0030 N7783MOrourke James Kevin · Omaha, NES/N 22-0031 N7784GAll2fly LLC · Atlanta, GABuilt 1970 · S/N 17259484 N7785MPalermo Michael S · Carter Lake, IABuilt 1974 · S/N 22-0033 N7786GRcm Aviation LLC · North Clarendon, VTFirst renewal noticeBuilt 1970 · S/N 17259486 N7787Barnett Charles · St. PeterBuilt 1974 · S/N 1225 N7787M628 Investments LLC · Stanley, NDBuilt 1974 · S/N 22-0035 N7788MMcreynolds Michael A · Sikeston, MOBuilt 1974 · S/N 20-0022 N7788VMaltenfort Andrew J · Culpeper, VABuilt 1970 · S/N 700055 N7789MRipato Peter A · Maysville, KYBuilt 1974 · S/N 20-0023 N778ACSchaefer Timothy R · Willcox, AZBuilt 1997 · S/N 381-97 N778RDKilo Golf Aviation LLC · St Simons Island, GABuilt 1976 · S/N 17702550 N7791H2 Aviation LLC · Middlebury, INBuilt 1979 · S/N 17272464 N7792MSchwam Andrew M · Pullman, WABuilt 1974 · S/N 21-0037 N7793MRegistration Pending · Bloomsburg, PARegistration pendingBuilt 1974 · S/N 21-0038 N7798MFessler Brian Clark · Centennial, COBuilt 1974 · S/N 22-0040 N7799MMazzillo Paul J · Madeira Beach, FLBuilt 1974 · S/N 22-0041 N779GS779 Aviation LLC · Dover, DEBuilt 1972 · S/N 303-72 N779JNTorque Aviation Inc · Smithfield, VABuilt 1978 · S/N 24-0605 N779PTMacon Air LLC · Franklin, NCBuilt 1976 · S/N 17266667 N779RDCustom Fire Apparatus Inc · Osceola, WIBuilt 2006 · S/N 1425-2007 N77ATRegistered aircraftBuilt 1981 · S/N 24-1233 N77BVRegistered aircraftBuilt 1979 · S/N P21000221 N77DHBramon Bruce M · Sunrise Beach, MOBuilt 1968 · S/N 17257127 N77EBBowles Alan B · Georgetown, TXBuilt 1966 · S/N 1084 N77EGParr Frank T · Pawleys Island, SCBuilt 1993 · S/N 24-3316 N77ERFrech Betty J Trustee · Columbia, MOBuilt 1977 · S/N 17269518 N77GATaliaferro John C · Abilene, TXBuilt 2003 · S/N 471-2003 N77GSSouth Carolina Flyers LLC · Aiken, SCBuilt 1981 · S/N P21000613 N77KRMarsh Aviation LLC · Old Lyme, CTBuilt 1981 · S/N P21000703 N77LNNass Edwin L · Port Orange, FLBuilt 1982 · S/N R18201873 N77RASky West Aviation Inc Trustee · Albuquerque, NMBuilt 1980 · S/N 21063846 N77XZRed Rocket Holding Co LLC · Boca Raton, FLS/N 38-78A0033 N7800GSale Reported · Roseville, MNSale reported, pending cancellationBuilt 1970 · S/N 17259500 N78027Cramlet Kirk T · Woodlake, CABuilt 1968 · S/N 17257467 N7802VKruger Matthew J · San Francisco, CABuilt 1964 · S/N 2808 N7803ESterling Paul M · Goodyear, AZS/N 38-79A1120 N7803GTomlin Jonathan S · Georgetown, OHS/N 17259503 N7803QSterling Paul M · Goodyear, AZS/N 38-79A1141 N7803VArtlip James · Wake Forest, NCS/N 2787 N7804GWells Adam · New Lexington, OHBuilt 1970 · S/N 17259504 N7804VVickers David Dewayne · Douglas, GABuilt 1964 · S/N 2788 N7805GArgabright John · Waterford, OHBuilt 1970 · S/N 17259505 N78066Orlandi Properties LLC · Blairstown, NJBuilt 1968 · S/N 17257470 N7806GAircraft Management Services Inc · Milton, FLBuilt 1970 · S/N 17259506 N7806VMouriz Javier · Leesburg, FLBuilt 1964 · S/N 2790 N78076Clinton Aeroclub · Clinton, IABuilt 1968 · S/N 17257472

Back to AD 80-25-07 R1