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.

N707CTShaak John C · Newnan, GABuilt 1978 · S/N R18200320 N707DRRichardson Douglas · Goodlettsville, TNBuilt 1970 · S/N 17701458 N707GLVoler Dans La Gloire LLC · Narberth, PABuilt 1976 · S/N 0729 N707GPIntermountain Air Inc · Colorado Springs, COBuilt 2024 · S/N 1218-2024 N707GSHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279648 N707JLCanova Frederick M · Delray Beach, FLBuilt 1994 · S/N 24-3331 N707LTSlater Timothy · Santa Rosa, CAS/N 24-1167 N707PPattison Bradley D · Gig Harbor, WABuilt 1975 · S/N 17266295 N707RJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1990 · S/N 243173 N707RMWilkes Jack M · Port Orchard, WABuilt 1976 · S/N 0737 N707RTRomeo Tango LLC · Indianapolis, INBuilt 1999 · S/N 1262-99 N707UJInternational Air Services Inc Trustee · Carson City, NVS/N 17262019 N707XJSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1969 · S/N 17701340 N7080QFerraro Paul · Seattle, WABuilt 1972 · S/N 17260380 N7081JHumphrey Neil F · Laramie, WYS/N 665-74 N7082GBbt Inc · Wilmington, DEBuilt 1969 · S/N 17258782 N7082QAmerican Patrols Inc · Midland, TXBuilt 1972 · S/N 17260382 N7083GMassie Robert G · Whitewater, WIBuilt 1969 · S/N 17258783 N7083QSevensixzerozero LLC · Boerne, TXBuilt 1972 · S/N 17260383 N7084QMarcks Jason M · Shiocton, WIFirst renewal noticeS/N 17260384 N7085GRegistered aircraftBuilt 1969 · S/N 17258785 N7086GSniffen Wesley H · Sycamore, OHBuilt 1969 · S/N 17258786 N7087GRavindran Manoj · Clarksville, TNBuilt 1970 · S/N 17258787 N7087VRanger Aviation LLC · Memphis, TNBuilt 1976 · S/N 20-1213 N7088GSardeis LLC · River Hills, WIS/N 17258788 N7089VFitts James M · San Antonio, TXBuilt 1976 · S/N 20-1215 N708TEAileron Aviation Inc · Cookeville, TNBuilt 1978 · S/N 17270934 N7091GSkylark Flight Training LLC · Wilmington, DEBuilt 1969 · S/N 17258791 N7091VFreimund Chandler R · Big Horn, WYBuilt 1976 · S/N 20-1217 N7092GAmick Thomas C · Newberry, SCBuilt 1969 · S/N 17258792 N7092VTextor William E · Springfield, MOBuilt 1976 · S/N 20-1218 N7093GAero Performance LLC · Scooba, MSBuilt 1969 · S/N 17258793 N7093VGary Robert M · Folsom, CABuilt 1976 · S/N 22-1421 N7094GJohnson And Assoc · Davenport, IABuilt 1969 · S/N 17258794 N7094QRegistered aircraftBuilt 1972 · S/N 17260394 N7094VMason Gary W · Rockledge, FLBuilt 1976 · S/N 22-1422 N7095GHunter John Bockett · Riverton, NJBuilt 1969 · S/N 17258795 N7095QWong Henry L III · Lake Forest, CABuilt 1972 · S/N 17260395 N7097GMurdy David C · Round Rock, TXBuilt 1969 · S/N 17258797 N7099GHunt Howard E · Martinsville, ILBuilt 1969 · S/N 17258799 N7099QVenaleck John T · Painesville, OHBuilt 1972 · S/N 17260399 N709MWGrant Michael R · South Weber, UTBuilt 1968 · S/N 172-56629 N709PTCappe Investment Group LLC · Homestead, FLS/N 17261533 N70DMMl Flight Services LLC · Miami, FLBuilt 1974 · S/N 17263728 N70GBVinter Mooney LLC · Philadelphia, PABuilt 1976 · S/N 20-1196 N70KPPrichard Kevin L · Enterprise, KSBuilt 1969 · S/N 17257954 N70SFFred Stuart L · Houston, TXBuilt 2005 · S/N 493-2005 N70TPhillips Fire Design LLC · Colorado Springs, COS/N 3008 N70TASixty Three Charlie Zulu Inc · Thonotosassa, FLBuilt 1979 · S/N 17272891 N7100EStrickler Elizabeth D · Ringgold, TXBuilt 1984 · S/N 1215-84

Back to AD 80-25-07 R1