Skip to content

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.

N2355YSchwarz Enterprises LLC · Huntington Beach, CABuilt 1967 · S/N 17700155 N2356Dunn Cole E · Florala, ALBuilt 1973 · S/N 17261946 N23575Registered aircraftBuilt 1965 · S/N 838 N2357PDix Walter R Jr · Winter Haven, FLBuilt 1979 · S/N 38-79A0961 N2358SBornhoft Jerome T · Riverton, WYBuilt 1979 · S/N R18201333 N2359DRobbins Carl K · Columbia X Rd, PAS/N 38-79A0281 N2359YWadsworth Edwin Allen · Sarasota, FLBuilt 1967 · S/N 17700159 N235ACLetourneau University · Longview, TXBuilt 2005 · S/N 1394-2005 N235AZSchlenker David D · Marine St Crx, MNBuilt 1980 · S/N R18201658 N235NYCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1981 · S/N 17274911 N235SAJkt LLC · Douglas, WYBuilt 2008 · S/N 1445-2008 N235WJmzb Leasing LLC · Amarillo, TXBuilt 1979 · S/N 21063206 N2361NBrewer Philip T · Bartlett, TNBuilt 1979 · S/N 38-79A0807 N2363NGeneral Aviation Support Corp · Rosamond, CANon-citizen corporation, flight hours not reportedS/N 38-79A0809 N2363PRoybal Jesse U · Kingman, AZBuilt 1979 · S/N 38-79A0963 N2363YPlane Pro Aviation LLC · Shelby, NCBuilt 1967 · S/N 17700163 N2364NNess Timothy J · Alexandria, MNBuilt 1979 · S/N 38-79A0810 N2365ADavedish LLC · South Fork, COBuilt 1978 · S/N 38-78A0657 N2365CStrolin LLC · Maple Valley, WABuilt 1978 · S/N R18200162 N2365DSpurlock James D · Headland, ALBuilt 1978 · S/N 38-79A0284 N2368ETomasik John R · Lackawanna, NYS/N 38-78A0450 N2369YMischel John Patrick · Salyersville, KYBuilt 1967 · S/N 17700169 N236AFAero Fisheries Inc · Fort Pierce, FLBuilt 1976 · S/N 17267726 N236AGTroposphere Ventures LLC · Fond Du Lac, WIBuilt 1978 · S/N R18200788 N236JTRecord John · Apison, TNBuilt 1970 · S/N 786-71 N236NYCivil Air Patrol Inc · Maxwell Afb, ALS/N 17268975 N236PTmg Investment Properties LLC · Surprise, AZS/N P21000116 N236RCCarter Rodney D · Artesia, NMBuilt 1983 · S/N R18201963 N2370BStrawberry Aviation Inc · Watsonville, CABuilt 1978 · S/N 38-79A0028 N2371ETmc Shooting Range Specialist Inc · Valencia, CAS/N 17271254 N2371LPiercy Brian K · San Anselmo, CABuilt 1979 · S/N 38-79A0733 N2372AOquinn Timothy M · Tehachapi, CABuilt 1978 · S/N 38-78A0661 N2372CMartin Land Improvement Inc · Elk Rapids, MIBuilt 1978 · S/N R18200164 N2372KKremer Charles A · Mckinney, TXS/N 38-79A0597 N23737Anderson Karl · Grant, ALS/N 38-79A1048 N23738Laureano Reynaldo · Murfreesboro, TNBuilt 1979 · S/N 38-79A1049 N2373CDs Flight Services LLC · Battle Ground, WABuilt 1978 · S/N R18200165 N2374CJackson Jeffrey D · Elk City, OKBuilt 1978 · S/N R18200166 N2374LFrederick Calvin · Homestead, FLBuilt 1979 · S/N 38-79A0687 N2375CEverwind Aviation LLC · Kalispell, MTBuilt 1978 · S/N R18200167 N2377EBeck Roger M Trustee · Goode, VABuilt 1978 · S/N 17271256 N2378BEssler Kim L · Garrison, NDBuilt 1978 · S/N 38-79A0029 N2378FPiper Aircraft Inc · Vero Beach, FLS/N 38-79A0409 N2379CWest Country Aviation Inc Trustee · Wilmington, DEBuilt 1978 · S/N R18200170 N2379GDesselle Howard J III · Marksville, LAS/N 38-79A0509 N2379PHendrix Kim R · Cheboygan, MIBuilt 1979 · S/N 38-79A0970 N2379YThelwell Llansley · Frisco, TXBuilt 1967 · S/N 17700179 N23800Adams Michael S · Huntsville, ALBuilt 1979 · S/N 38-79A1055 N2380KPiper Aircraft Inc · Vero Beach, FLBuilt 1979 · S/N 38-79A0603 N2381KCarolinas Energy Associates LLC · Hays, NCBuilt 1979 · S/N 38-79A0605

Back to AD 80-25-07 R1