Skip to content

Registered aircraft · 56,580

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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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:79-10-14-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.

N42554Cagle Kimberlee S · Houston, TXBuilt 1968 · S/N 18259075 N42556Quality Contractors LLC · Deary, IDBuilt 1968 · S/N 18259076 N42560Mallory Mark P Trustee · Independence, ORBuilt 1968 · S/N 18259077 N42564Williams Robert E · Clermont, GABuilt 1968 · S/N 18259079 N42565Pops Space LLC · Luther, OKBuilt 1968 · S/N 18259080 N42567C & T Aviation LLC · Seattle, WABuilt 1968 · S/N 18259081 N4256LStewart Stephanie J · Lakeland, GABuilt 1966 · S/N 17254325 N4256QBurnham Cessna N4256q LLC · Carr, COBuilt 1971 · S/N 17260156 N4256UGjm Aviation LLC · Petal, MSBuilt 1963 · S/N 15060256 N42572Modi Yogini · Homestead, FLS/N 18259084 N42576Larch Hill Laboratory LLC · Earlville, NYBuilt 1968 · S/N 18259087 N42577Buttered Landings LLC · Hutchinson, KSS/N 18259088 N42578Hodges James M Jr · Manchester, GABuilt 1968 · S/N 18259089 N42580Cox Bruce R · Brock, TXBuilt 1968 · S/N 18259091 N42589Haas Kile B · Monette, ARBuilt 1973 · S/N 18052365 N42591Mcferrin Clinton J · Kyle, TXBuilt 1968 · S/N 18259094 N42594Wunsch Larry K · Fond Du Lac, WIBuilt 1968 · S/N 18259095 N42599Avco Patrol LLC · Lyndon, KSBuilt 1968 · S/N 18259098 N4259FGuynes Ronald A · Two Rivers, WIBuilt 1958 · S/N 46159 N4259LBrown Lawrence D · Memphis, TNBuilt 1966 · S/N 17254328 N4259VKurt Robert F · Rose Hill, KSS/N 18615 N425CPCivil Air Patrol Inc · Maxwell Afb, ALBuilt 2001 · S/N 172S8687 N425CRAtp Aircraft 8 LLC · Wilmington, DEBuilt 2014 · S/N 172S11449 N425DBWings Over Texas Holdings LLC · Denton, TXBuilt 1975 · S/N 17266404 N425DLTotal Flight Aircraft Leasing LLC · Apex, NCBuilt 1979 · S/N 172RG0143 N425EJCity Of Portland · Portland, ORBuilt 2015 · S/N 18282372 N425KAHerrmann Laura Jean Trustee · Saint Bonifacius, MNS/N 18268454 N425KPBrown David B · Cumberland, VAS/N 18281383 N425MBPauls Valley Fly Boys LLC · Davis, OKBuilt 1976 · S/N 18264927 N425PKGood Flight LLC · San Luis Obispo, CABuilt 2004 · S/N 18281449 N425PRHorizon Technical Services Inc · Farmingdale, NYBuilt 1977 · S/N 18266202 N425RBAkguc Cengiz · Lantana, TXBuilt 1962 · S/N 18254214 N425TASkyhawks Inc · Westminster, COBuilt 1976 · S/N 18264951 N42604Lawrie Daniel A · Mesa, AZBuilt 1968 · S/N 18259100 N42606Ramon Jose J · West Palm Beach, FLBuilt 1968 · S/N 18259101 N42609Jcr Ag LLC · Frederick, OKBuilt 1980 · S/N 18803666 N4260FAyers Frank E · Coulee Dam, WABuilt 1958 · S/N 46160 N4260LTrueman Jeffrey A · Clear, AKBuilt 1966 · S/N 17254329 N4260QLevin Robert G · Roseburg, ORBuilt 1971 · S/N 17260160 N4260UGebhart Travis D · Meadow, SDBuilt 1963 · S/N 15060260 N4260VFranks Marvin L · Cedar Key, FLBuilt 1948 · S/N 18616 N42610Meadows Marcus · Anchorage, AKS/N 18052366 N42615N42615 LLC · Shorewood, ILBuilt 1968 · S/N 18259107 N4261FPeri Richard A · Burgess, VABuilt 1958 · S/N 46161 N4261LCochrane Warren H Jr · Carabaset Vly, MEBuilt 1966 · S/N 17254330 N4261VWells Bryan G · Stephenville, TXBuilt 1948 · S/N 18617 N42623Boulware Randall R Trustee · Bolivar, MOBuilt 1968 · S/N 18259110 N42625Tull Matthew W · Niceville, FLBuilt 1968 · S/N 18259112 N42627Henry Mark A · Dickinson, TXS/N 18259114 N4262ARamaswamy Ashok · Clearwater Beach, FLS/N 27105

Back to AD 79-10-14 R1