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.

N37WTFaulk County Flying Club Inc · Faulkton, SDBuilt 1978 · S/N 17271385 N37ZQMagnum Aviation LLC · Goff, KSBuilt 1978 · S/N 15282684 N3800FCampbell Joseph P · Vail, AZBuilt 1977 · S/N 0768 N3803FPiercy Ronald S · Moses Lake, WABuilt 1977 · S/N 0771 N3803HStaib Matthew · Cambridge, MABuilt 1980 · S/N 24-0945 N3803QAmerican Patrols Inc · Midland, TXBuilt 1971 · S/N 17259903 N3804QWings Over Texas Holdings LLC · Denton, TXBuilt 1971 · S/N 17259904 N3805FSmith James E Trustee · Kalispell, MTBuilt 1977 · S/N 0773 N3805NHopkins Michael P · Granbury, TXBuilt 1968 · S/N 680124 N3806FSkytours Aerial LLC · Jackson, MIBuilt 1977 · S/N 0774 N3807FDeno Gerald G · Battle Creek, MIBuilt 1977 · S/N 0775 N3808FChandler Air Service Inc · Chandler, AZBuilt 1977 · S/N 0776 N380KCitabria Corporation · Wilmington, DEBuilt 2011 · S/N 543-2011 N380RADarnell Charles Bert · Glen Allan, MSBuilt 2005 · S/N 1380-2005 N380XBourgeois Olivier F · North Andover, MABuilt 1975 · S/N 177RG0751 N3810FTomco Stores Ltd · Ruidoso, NMBuilt 1977 · S/N 0778 N3812FGreat Lakes Aircraft LLC · Palmer Lake, COBuilt 1977 · S/N 0780 N3813FN3813f Inc · Wilmington, DEBuilt 1977 · S/N 0781 N3813HJohnson Mark A · Cypress, TXBuilt 1980 · S/N 24-1043 N3814FSnuffer Michael K · Reno, NVBuilt 1977 · S/N 0782 N3815FOrr Charles W III · San Ramon, CABuilt 1977 · S/N 0783 N3816FHotzel Jeffrey F · Gladstone, MOBuilt 1977 · S/N 0784 N3816QGoli Aviation LLC · Raleigh, NCBuilt 1971 · S/N 17259916 N3817FKirker Howard A · Rio Verde, AZS/N 0785 N3817QMoses Aviation Services LLC · Uvalde, TXS/N 17259917 N3818QRanch Hand Flying Club Inc · Gardiner, NYBuilt 1972 · S/N 17259918 N3819FBuntings Grassroots Aviation LLC · Selbyville, DEFirst renewal noticeS/N 0787 N3819QGulf Coast Aero Club Inc · Sarasota, FLBuilt 1971 · S/N 17259919 N381AHGeodata Aircraft Management Inc · Wilmington, DEBuilt 1979 · S/N R18200919 N381AVNelson Allen R · Oakdale, MNS/N 38-78A0638 N381CAOltman Neil R · Sandia Park, NMBuilt 2004 · S/N 1368-2004 N381DFSouth & Silver Aviation LLC · Pikesville, MDBuilt 1977 · S/N 17269718 N381DMStuart John R · Taylorsville, KYBuilt 2000 · S/N 865-2000 N381JUS Aviation Group LLC · Denton, TXBuilt 1980 · S/N 17274183 N381MAKnight Wings LLC · Matthews, NCBuilt 2005 · S/N 1397-2005 N381MBStrobridge Mark D · Bunnell, FLBuilt 1981 · S/N 17275303 N381MGMissionary Air Group Inc · Burlington, NCBuilt 1975 · S/N 17265873 N3821FKennedy Karen E · Gulf Breeze, FLBuilt 1977 · S/N 0789 N3822FBelser Mark · Avon, OHBuilt 1977 · S/N 0790 N3822QMatanane Roke C · Barrigada, GUBuilt 1971 · S/N 17259922 N3823FGovednik Francis J · Flower Mound, TXBuilt 1977 · S/N 0791 N3825QFischer Roger G · Torrance, CABuilt 1971 · S/N 17259925 N3827HPlane1 LLC · Lander, WYBuilt 1980 · S/N 24-0953 N3829PRalphs Thomas A · Solana Beach, CABuilt 1978 · S/N P21000062 N3829QMiller Randall J · Arlington, WABuilt 1971 · S/N 17259929 N382CFTurner Noah S · Gilbert, AZBuilt 1979 · S/N 38-79A1043 N382DFDream Flight LLC · Westminster, MDBuilt 1976 · S/N 17268233 N382JNSilver Sky Air LLC · Fresno, CABuilt 1973 · S/N 17262794 N382MAFly To Sea LLC · Stanford, CABuilt 2004 · S/N 487-2004 N382PTTechnical Education Services Inc · Virginia Beach, VABuilt 1978 · S/N 38-78A0003

Back to AD 80-25-07 R1