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.

N1602GHenry Thomas J · Ellicott City, MDBuilt 1968 · S/N 613 N1602VRegistration Pending · Lucas, TXRegistration pendingBuilt 1974 · S/N 17263690 N1603EWright Michael A · Advance, NCBuilt 1978 · S/N 17271062 N1603GCp Aviation Inc · Santa Paula, CABuilt 1968 · S/N 609 N1604GMut Henry · Brookshire, TXBuilt 1968 · S/N 101 N1605GAllen Matthew C · Pomona, CABuilt 1968 · S/N 99 N16066Thompson Derek D Jr · Dunkirk, MDBuilt 1976 · S/N 17702482 N1606GNigri David A · Smithfield, RIBuilt 1968 · S/N 112 N1607HHanson Jeffrey L · Fuquay Varina, NCBuilt 1975 · S/N 177RG0780 N1608GDrexler William G · Peyton, COBuilt 1968 · S/N 105 N1609EEilenfeld Teresa · Mansfield, OHBuilt 1978 · S/N 17271065 N160BCPridmore Reginald C · Laughlin, NVS/N 457-2004 N160DPrice Paul L · Lancaster, VABuilt 1966 · S/N 3448 N160FSModi Yogini · Homestead, FLBuilt 1979 · S/N 17272752 N1610GVeenstra Timothy S · Wasilla, AKS/N 114 N1611HPlane Fun Inc Tr Trustee · Snellville, GABuilt 1975 · S/N 177RG0784 N1612EPavlovitch Marion T · Northridge, CAFirst renewal noticeBuilt 1978 · S/N 17271066 N16134Adibi Saeed · Huntsville, ALBuilt 1976 · S/N 17702485 N16137Hines Roger E · Greenville, OHBuilt 1976 · S/N 17702487 N1613GInglis Jeffrey R · Hampton, NHBuilt 1968 · S/N 618 N1613HHampton William R · Marietta, GAFirst renewal noticeBuilt 1975 · S/N 177RG0786 N1613VMcewen Michael A M D · Gadsden, ALBuilt 1974 · S/N 17263692 N1614GGriffin Donald A · Alma, ILBuilt 1968 · S/N 607 N1615EFisher Ralph B · Lutz, FLBuilt 1978 · S/N 17271067 N1615VFrance Jeffrey A · Reedville, VABuilt 1974 · S/N 17263693 N1616GGorton Trice J · Anchorage, AKBuilt 1968 · S/N 620 N1616HMayworm Jeffrey A · Ocala, FLBuilt 1975 · S/N 177RG0789 N1617GDuch Jose M · Miami, FLBuilt 1968 · S/N 621 N1617HFlying Cloud Cherokees Inc · Chanhassen, MNBuilt 1975 · S/N 177RG0790 N1617VCook Timothy D · Ashville, NYBuilt 1974 · S/N 17263694 N16185Schwartz David W · Windsor, NYBuilt 1976 · S/N 17702491 N1618GBlue Moon Flying Club LLC · Westminster, MDBuilt 1968 · S/N 622 N1618HMemrick Paul · Cedar Park, TXBuilt 1975 · S/N 177RG0791 N16199Allbritton John Mark Trustee · Oakland, TNBuilt 1976 · S/N 17702493 N161FKaminski Michael Jr · Ford City, PABuilt 1981 · S/N 24-1076 N161GLEdwards Jeffrey L · Port Orange, FLBuilt 1978 · S/N 0814 N161GTYellow Jacket Flying Club Inc · Atlanta, GABuilt 1986 · S/N 17276650 N161MPJb Aviation LLC · Newark, OHBuilt 1992 · S/N 24-3276 N161SAAviation Consultants Inc DBA · San Luis Obispo, CABuilt 2002 · S/N 901-2002 N161SEOquinn Timothy M · Tehachapi, CABuilt 2006 · S/N 1027-2006 N161SG3bs Aviation LLC · Wilmington, DEBuilt 2005 · S/N 1000-2005 N161WFMaier Diane K · Underwood, WABuilt 2017 · S/N 1472-2016 N1620GDrexler Charles T · Albuquerque, NMBuilt 1968 · S/N 123 N1621HDavis Vance · Del Valle, TXS/N 177RG0794 N1622HSweeney Kay M · Kirkland, WABuilt 1975 · S/N 177RG0795 N1624GBarnett William M · Wasilla, AKBuilt 1968 · S/N 623 N1625GPippert Jim · Dysart, IABuilt 1968 · S/N 127 N1625UFly2k LLC · San Jose, CABuilt 1982 · S/N 21064710 N1627EWichterman George J Trustee · Fort Myers, FLBuilt 1978 · S/N 17271070 N1628GBistline Quentin J · Pahrump, NVS/N 626

Back to AD 80-25-07 R1