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.

N7161QFrigate Aviation LLC · Smithville, OHBuilt 1972 · S/N 17260461 N7161UJones Barkley · Moultrie, GABuilt 1964 · S/N 2743 N7161VKenney Anthony G · Oviedo, FLFirst renewal noticeBuilt 1974 · S/N 22-0070 N7162GWmg Security · Shelton, WAS/N 17258862 N7162UEcklund Scott Trustee · Brandon, SDBuilt 1964 · S/N 2744 N7163GDs Flight Services LLC · Battle Ground, WABuilt 1969 · S/N 17258863 N7163UPatterson John M II · Frankfort, KYBuilt 1964 · S/N 2745 N7163VRegistered aircraftBuilt 1974 · S/N 22-0072 N7164UKnapp Schuyler S K · Upperville, VABuilt 1964 · S/N 2746 N7164VB&J Aviation LLC · Saint Louis, MOBuilt 1974 · S/N 22-0073 N7165GExecutive Flight Institute LLC · Murrieta, CAS/N 17258865 N7168GDurbin John W · Lovington, ILBuilt 1969 · S/N 17258868 N7169VPrh Farms Inc · Gettysburg, SDBuilt 1974 · S/N 22-0078 N716ACAlexandrov Boyan · Reno, NVBuilt 1993 · S/N 725-93 N716JRegistered aircraftBuilt 1989 · S/N 24-3119 N7170GSs Skyways LLC · Becker, MNBuilt 1969 · S/N 17258870 N7170UWorley Ronald W · West Jefferson, NCBuilt 1964 · S/N 2752 N7170VKrack John L Trustee · Fridley, MNBuilt 1974 · S/N 20-0042 N7171QMcnamara Bradley W · Seattle, WABuilt 1972 · S/N 17260471 N71728Guskea Andrew E · Jericho, VTBuilt 1962 · S/N 2186 N7172QRounds Agronomy LLC · Pierre, SDS/N 17260472 N7172UMark21-Charlie LLC · Brownsburg, INBuilt 1964 · S/N 2754 N7172VGanji Borna · West Windsor, NJBuilt 1974 · S/N 20-0044 N7173GSale Reported · Haiku, HISale reportedBuilt 1969 · S/N 17258873 N7173QWesterly Av Group LLC · Westerly, RIS/N 17260473 N7174GMaloney John T · Deer Park, NYBuilt 1969 · S/N 17258874 N7174UVondross James B · Portland, ORBuilt 1964 · S/N 2756 N7174VEast Carolina Aviation LLC · Camden, NCBuilt 1974 · S/N 20-0046 N7175GMontgomery Monty · Cave Spring, GABuilt 1969 · S/N 17258875 N7175UWagner Mark · Grass Valley, CAS/N 2757 N7176QJax Beach Aviation LLC · Jacksonville, FLBuilt 1972 · S/N 17260476 N7176VZammit Joseph A · Riverside, CAS/N 21-0056 N7177GCoats George A · The Woodlands, TXBuilt 1969 · S/N 17258877 N7177QLeonard William K · Seattle, WABuilt 1972 · S/N 17260477 N7178QSkylens LLC · Hammond, LABuilt 1972 · S/N 17260478 N7178UBell Construction Inc · Napa, CABuilt 1964 · S/N 2760 N7178VUhl Jack G · Bloomington, MNS/N 21-0058 N7179UBarbee James E · Mason Neck, VAS/N 2761 N717ACKcd Aviation LLC · Tonica, ILBuilt 1995 · S/N 757-95 N717BSTla Inc · Middletown, DEBuilt 1977 · S/N 24-0192 N717BYWhite Kenneth · Rancho Cordova, CABuilt 1965 · S/N 2957 N717CEHuffman Jacob M III · Burleson, TXBuilt 1976 · S/N 17267113 N717GMustang Sally Aviation LLC · Camden, SCBuilt 1976 · S/N 17267597 N717LVPage Wayne N · Corning, IABuilt 2004 · S/N 970-2004 N717MEMotormod LLC · Florence, SCS/N 17273458 N717MRSt Johns Aviation Partners II · Beaumont, TXBuilt 1980 · S/N P21000601 N717NARegistered aircraftBuilt 1972 · S/N 17701760 N717RFWings Flight Enterprises Inc · Danville, KYBuilt 1977 · S/N 17269901 N717SThornapple Flying Academy LLC · Middleville, MIBuilt 1968 · S/N 680202 N7180GPearman Properties LLC · Branson, MOBuilt 1970 · S/N 17258880

Back to AD 80-25-07 R1