Skip to content

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.

N722AARobinson Charles F Jr · Portage, MIBuilt 1972 · S/N 17261274 N722CSBoccaccio Peter Anthony · Burke, SDBuilt 1962 · S/N 2171 N722ELBristow Bryan M · Albany, ORBuilt 1981 · S/N 21064332 N722RRAncira Autos LLC · San Antonio, TXBuilt 1979 · S/N 21063651 N722SSWind Wizards Inc · El Paso, TXBuilt 1974 · S/N 287-74 N7230GMaples Kevin T · Pueblo, COS/N 17258930 N7230QArcade Flying Club Inc · El Dorado Hills, CABuilt 1972 · S/N 17260530 N7231QDsr-Cherokee 180 LLC · Dallas, TXS/N 17260531 N7234GBittenbender Peter E · Grand Rapids, MNFirst renewal noticeBuilt 1970 · S/N 17258934 N7234QLavinio Stephen E · Southampton, NYBuilt 1972 · S/N 17260534 N7235GMcnair William H · Gold Beach, ORBuilt 1970 · S/N 17258935 N7236QTeren Nelson F · Friday Harbor, WABuilt 1972 · S/N 17260536 N7237GIvoprop Corp · Long Beach, CABuilt 1970 · S/N 17258937 N7237QMartin Bach Aviation LLC · Cornelius, NCBuilt 1972 · S/N 17260537 N723AKFrohnapfel Mark T · Cordova, AKBuilt 1974 · S/N 76-74 N723CLVan Why Johnathan Ryan · Corvallis, ORBuilt 1999 · S/N 829-99 N723CMOmbra Aria LLC · Dover, DEBuilt 1978 · S/N 15282823 N723GPuerta Jose Fernando Del Valle · Miami, FLBuilt 1976 · S/N 17268008 N723LPDaly Robert · Plainview, NYBuilt 1994 · S/N 24-3343 N723SBFreeman-Benson Bjorn N · Portland, ORS/N 17701786 N723THSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1977 · S/N 15281348 N7240GKendallville Flying Club Inc · Auburn, INBuilt 1970 · S/N 17258940 N72421N83882 Inc · Huntington, NYBuilt 1968 · S/N 17257407 N7242GIrizarry Heriberto J · Homestead, FLBuilt 1970 · S/N 17258942 N7243GKrumbine David A · Lebanon, PABuilt 1970 · S/N 17258943 N7244QBuckley Gregory L · Melba, IDS/N 17260544 N7246GHale Warren P · Martinsburg, MOBuilt 1970 · S/N 17258946 N7246QHaines Anne K · Ligonier, PABuilt 1972 · S/N 17260546 N7248QEricson Steven L · Dorris, CABuilt 1972 · S/N 17260548 N72493Cook Tyler · Seldovia, AKBuilt 1975 · S/N 18775 N7249GTate Donald E · Jonesburg, MOBuilt 1970 · S/N 17258949 N7249QTrailgate Tailgate Systems Inc · Belle Vernon, PABuilt 1972 · S/N 17260549 N724JMTygielski Brent R · Clarkston, MIBuilt 1963 · S/N 2502 N724MSNannenga Fredrick Jr · Hillsboro, ORBuilt 1967 · S/N 298 N724TMMorcom Aviation Services Inc DBA · Everett, WABuilt 1974 · S/N 17262971 N724TXStratus Aviation LLC DBA · Vacaville, CABuilt 1974 · S/N 17263381 N7250NSimon Jevon · Buckley, WABuilt 1979 · S/N 21063213 N7250QSale Reported · Crystal, MNSale reported, pending cancellationBuilt 1972 · S/N 17260550 N7251QGarcia Crystal M · Brownsville, ORBuilt 1972 · S/N 17260551 N7252GLeaders Flying Service LLC · Clear Lake, MNBuilt 1970 · S/N 17258952 N7252QRobbins Aviation LLC · Scottsbluff, NEBuilt 1972 · S/N 17260552 N7253GOne Mile LLC · Canton, GABuilt 1970 · S/N 17258953 N7253QHarry'S Hawks · Wells, MNBuilt 1972 · S/N 17260553 N7254QRegistration Pending · Phoenix, AZRegistration pendingBuilt 1972 · S/N 17260554 N7255QSierra Sky Aviation LLC · Kalispell, MTS/N 17260555 N7257QSmith Henry C III · Essexville, MIBuilt 1972 · S/N 17260557 N7258International Air Services Inc Trustee · Carson City, NVBuilt 1980 · S/N 172RG-0508 N7259QForbes Gregory Allan · Lowell, MIBuilt 1972 · S/N 17260559 N725ACFiorini Jay · Turlock, CABuilt 1999 · S/N 1254-98 N725BBScenic Concepts LLC · La Crosse, WIBuilt 1976 · S/N 17267802

Back to AD 80-25-07 R1