Skip to content

Registered aircraft · 56,576

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.

N11139Olson Philip D · Garden Plain, KSBuilt 1973 · S/N 15075216 N1113YPrecision Design Inc · Weatherford, OKS/N 15059513 N11142Galion Air Inc · Galion, OHBuilt 1973 · S/N 15075218 N11144Hawkins Larue S · Carrollton, MOBuilt 1973 · S/N 15075220 N11145Martin Walter J · Ocala, FLBuilt 1973 · S/N 15075221 N11146Williams Ryan C · East Helena, MTBuilt 1973 · S/N 15075222 N11149Schmitt Rudy · Brookshire, TXS/N 15075225 N1114FRegistration Pending · Florence, SCRegistration pendingBuilt 1966 · S/N 17254709 N1114TQuellette James L · Plymouth, CTBuilt 1965 · S/N 15061846 N1114YThompson Randy L · Anderson, CABuilt 1962 · S/N 15059514 N11156Mayer Randal J · Argusville, NDBuilt 1973 · S/N 15075230 N11157Patel Rahul G · Austin, TXBuilt 1973 · S/N 15075231 N1115UAvian Leasing LLC · Bremerton, WABuilt 1976 · S/N 17266851 N11169Cooper Donald L Jr · El Granada, CABuilt 1973 · S/N 15075236 N1116DOxman Warren L · Rhome, TXS/N 15680 N11172Skaaire Society · Madison, WIBuilt 1975 · S/N 17702327 N11173Miller William L Jr · Corinth, MSBuilt 1973 · S/N 15075238 N11179Holloway David · Auburn, CABuilt 1985 · S/N 18504436 N1117PD W Shimoda LLC · Itasca, ILBuilt 2005 · S/N 18281580 N1117THimes Austin M · Wentworth, MOBuilt 1965 · S/N 17252759 N1117UBhp Aviation · Santa Clara, CABuilt 1976 · S/N 17266852 N11182Smith Brian · Roanoke, TXBuilt 1979 · S/N 18266815 N11183Stancil James T · Jasper, GAS/N 15075243 N11185Stancil Joe E Jr · Eagle River, AKBuilt 1980 · S/N 18504044 N11186Round Engine Aero · Nashville, MIS/N 15075245 N11196Clark Joseph C · Avondale, PABuilt 1973 · S/N 15075250 N1119DChumble Ameya A · Duluth, MNBuilt 1951 · S/N 15683 N111AKKershaw Andrew H · Spring, TXBuilt 2025 · S/N 18283325 N111ATSkymaster Stc LLC · Mena, ARBuilt 1969 · S/N 337-1125 N111BLLandry Patrick Todd · Georgetown, TXBuilt 1979 · S/N 18503877 N111CAce'S Hangar LLC · Bentonville, ARBuilt 1974 · S/N 18502600 N111CJRegan Dennis W · Rochester, MNBuilt 1973 · S/N 18262621 N111CYSmody Michael S · Neelyville, MOBuilt 1974 · S/N 18263183 N111DEPespisa John · Hacienda Heights, CABuilt 1973 · S/N 18262712 N111EXNew Orleans Aviation LLC · Covington, LABuilt 1986 · S/N 17275024 N111EYHook Steven · Pasco, WABuilt 1974 · S/N 18502407 N111EZMayes Robert C · Boise, IDBuilt 1964 · S/N 1850753 N111GN111g LLC · Longmont, COBuilt 1974 · S/N 18502507 N111GFHuggins Stephen M · Eagle Creek, ORBuilt 1975 · S/N 18263578 N111HCBennett Miranda Mathis · Fairhope, ALBuilt 1975 · S/N 15077675 N111HKSky Peace Aviation LLC · Springdale, ARBuilt 2015 · S/N 18282377 N111HPFlying Aces Aero-Fleet Inc · Guyton, GABuilt 1984 · S/N 172RG1153 N111HSMacav Flight Training LLC · Abilene, TXBuilt 1965 · S/N 17253989 N111HVBga-Viation · Bennettsville, SCBuilt 1979 · S/N R1723289 N111KBRacoon Aviation LLC · San Antonio, TXS/N 18261460 N111KSKilo Sierra LLC · Monticello, INS/N 56476 N111LKnuth Dale G · Hartford, SDBuilt 1952 · S/N 20642 N111LHSuperior Aviation Gateway LLC · Tampa, FLBuilt 1977 · S/N 17269965 N111MFField Monica · Los Angeles, CABuilt 1963 · S/N 17250162 N111NJNew Jersey Forest Fire Service · Trenton, NJBuilt 1964 · S/N U206-0278

Back to AD 79-10-14 R1