Skip to content

Registered aircraft · 6,349

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-02-R2') 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-02-R2') 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-02-R2')
    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-02-R2')
  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-02-R2')
  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-02-R2')
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.

N64908Fauver Russell J · Hartsville, SCBuilt 1978 · S/N 15281470 N64912Suburban Air Corporation · Castro Valley, CABuilt 1978 · S/N 15281473 N64939Street Paul G · Anniston, ALBuilt 1978 · S/N 15281487 N64942Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15281489 N64944Dsr-Cherokee 180 LLC · Dallas, TXBuilt 1978 · S/N 15281490 N64949Heavy Metal Air LLC · Farmingdale, NYBuilt 1978 · S/N 15281494 N6496LTurn Key Aviation LLC · North Las Vegas, NVBuilt 1980 · S/N 15284420 N64971R&R Aero Services LLC · Eden Prairie, MNBuilt 1978 · S/N 15281505 N6497AHenry Mark Alan · Dickinson, TXS/N 38-78A0441 N64985Keenan Jim · Neenah, WIBuilt 1978 · S/N 15281512 N64987Stanford Jay J · St Marys, GAS/N 15281514 N64989Verderame Robert A · Metairie, LABuilt 1978 · S/N 15281516 N64EZSchrieber Robert L · Brunswick, GABuilt 2014 · S/N 120948-2013 N64GPWilkins Raymond E · Osceola, IABuilt 1965 · S/N 001 N64LZWilson Tony G · Bartlett, TNBuilt 1996 · S/N 1034 N64MKCavanaugh Sean M · Ottumwa, IABuilt 1966 · S/N 434 N6503HBrafford John Lee · Kings Mountain, NCBuilt 1979 · S/N 15284172 N6503MCentral Texas College · Killeen, TXBuilt 1980 · S/N 15284759 N6505HDe Creeft Joseph M · Homer, AKBuilt 1946 · S/N 19688 N6505MUrrea Hugo Edmundo Rincon · Katy, TXBuilt 1980 · S/N 15284760 N6509LSnohomish Flying Service Inc · Snohomish, WABuilt 1980 · S/N 15284425 N650LBHutchison Gil F · Salem, ORBuilt 2003 · S/N 1492 N6512LMetcalf David G · Amarillo, TXS/N AA1B-0312 N6516HArmenta Javier · Douglas, AZBuilt 1979 · S/N 15284175 N6516LSale Reported · Lonoke, ARSale reportedBuilt 1973 · S/N AA1B-0316 N6517LBrown Hunter J · Starkville, MSBuilt 1973 · S/N AA1B-0317 N6518LBergen Maxwell · Charlotte, NCBuilt 1973 · S/N AA1B-0318 N65199Long Island Aviators LLC · Seaford, NYBuilt 1980 · S/N 15284323 N6519LRegistration Pending · Saint David, AZRegistration pendingBuilt 1973 · S/N AA1B-0319 N651TPGray Dylan · Alliance, OHBuilt 2011 · S/N 65-7575 N6520LShiner Gary P · Wichita, KSBuilt 1974 · S/N AA1B-0320 N6521QAlpha Wings Inc · Willoughby, OHBuilt 1981 · S/N 15285266 N6525LMojonnier David Lindsey · Kingman, AZBuilt 1973 · S/N AA1B-0325 N6525PZrelak Patrick · Apple Valley, CABuilt 1981 · S/N 15285028 N6526LGreenwood George R · Concordia, KSBuilt 1973 · S/N AA1B-0326 N6528LCorbin Rex W · Benton, KSBuilt 1974 · S/N AA1B-0328 N6531LGaldino Aidan G · Franklin, TNBuilt 1973 · S/N AA1B-0331 N6534LAndreassen Andrew R · Pleasanton, NEBuilt 1980 · S/N 15284428 N6535LRodick John M · Hanson, MABuilt 1973 · S/N AA1B-0335 N6536PWings Over Texas Holdings LLC · Denton, TXBuilt 1981 · S/N 15285029 N65398Seeley Timothy C Trustee · Chico, CABuilt 1978 · S/N 15281526 N653MCDaily Joshua · Rochester, WAS/N 146 N65401Pea-Wayman Flight LLC · Daytona Beach, FLBuilt 1978 · S/N 15281529 N65407Clemson Flying Club Inc · Seneca, SCS/N 15281533 N65408Hendrix Aviation Inc · Plantation, FLBuilt 1978 · S/N 15281534 N6540LSmith Thomas E · Williamstown, MABuilt 1973 · S/N AA1B-0340 N65415Cal Aggie Flying Farmers Inc · Davis, CABuilt 1978 · S/N 15281537 N65417Frear Robert · N Redngtn Bch, FLBuilt 1978 · S/N 15281539 N6541LOse Leroy B · Thief River Falls, MNBuilt 1973 · S/N AA1B-0341 N65435Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15281550

Back to AD 80-25-02 R2