Skip to content

Registered aircraft · 40,471

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-04-03-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-04-03-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-04-03-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-04-03-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-04-03-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-04-03-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.

N75806Jones Bros Amc Jeep Inc · Harrison, ARBuilt 1976 · S/N 17267965 N75807Pearl River Community College · Poplarville, MSS/N 17267966 N75809C & S Flyers LLC · Grand Lake, LABuilt 1976 · S/N 17267967 N7580PWiseman Charles D · Orlando, FLS/N 24-2791 N7580YMeekin Michael · Sutton, AKBuilt 1965 · S/N 18-8300 N75816Lns Aviation LLC · Chandler, AZBuilt 1976 · S/N 17267973 N7581CGurr James E · Alden, MIBuilt 1957 · S/N 186 N7581GManasco Inc · Tucson, AZBuilt 1970 · S/N 17259281 N7581LPruitt Kerry P · Nacogdoches, TXBuilt 1975 · S/N 18-7509079 N7581RMiller Galen E · Lewistown, ILS/N 28-22343 N7581WSutherland Joel C · Greenbrier, TNBuilt 1964 · S/N 28-1523 N75820Zoviv Michael · Hollywood, FLBuilt 1976 · S/N 17267977 N75822International Air Services Inc Trustee · Carson City, NVBuilt 1976 · S/N 17267979 N75823Wings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 17267980 N75824Williams John S · Fort Walton Beach, FLBuilt 1976 · S/N 17267981 N75825Patrick Ronald D · Locust Grove, GAFirst renewal noticeBuilt 1976 · S/N 17267982 N75829Hofmann LLC · Blauvelt, NYBuilt 1976 · S/N 17267985 N7582CKnutson Wayne R · Tioga, NDBuilt 1957 · S/N 187 N7582GCapps Christopher T · Anchorage, AKBuilt 1970 · S/N 17259282 N7582WKoch Scott A · Voorhies, IABuilt 1964 · S/N 28-1524 N75831Mccall Freddie W · Century, FLBuilt 1976 · S/N 17267987 N75833Blees James E · Anchorage, AKBuilt 1976 · S/N 17267989 N75837Linder Ronald G · Fort Wayne, INBuilt 1976 · S/N 17267992 N75838Fadel Shaheen J · Charlotte, NCS/N 17267993 N75839Rocky Mountain Aircraft Services LLC · Broomfield, COBuilt 1976 · S/N 17267994 N7583DCulver Deborah M · Anchorage, AKBuilt 1957 · S/N 18-5879 N7583GPebworth Properties LLC · Auburn, WABuilt 1970 · S/N 17259283 N7583RFoster William E · Red Bluff, CABuilt 1966 · S/N 28-22150 N75840Planebros LLC · Bixby, OKBuilt 1976 · S/N 17267995 N75842Foree John Baird · New Castle, KYBuilt 1976 · S/N 17267997 N75844Command Aviation Inc · Bellingham, WABuilt 1976 · S/N 17267998 N75845Stark Russell Allen · Madison, WIBuilt 1976 · S/N 17267999 N75846Rodgers Lynn C · Springfield, MOBuilt 1976 · S/N 17268000 N7584RMurphey Larry D · Notus, IDBuilt 1966 · S/N 28-22151 N7585GCessna85g LLC · Manassas, VABuilt 1970 · S/N 17259285 N7585RArmy Air Force LLC · Los Lunas, NMBuilt 1966 · S/N 28-22152 N7585WCurrie Mark H · Justin, TXBuilt 1964 · S/N 28-1533 N75860Eastern Cincinnati Aviation Inc · Batavia, OHBuilt 1976 · S/N 17268005 N75866Gibson Aviation Services LLC · Menomonie, WIBuilt 1976 · S/N 17268009 N7586RReyes Michael · Hereford, TXBuilt 1966 · S/N 28-22153 N75871Blue Wing Flyer LLC · Marietta, GABuilt 1977 · S/N 17268011 N75874Walled Lake Flying Club · Waterford, MIBuilt 1976 · S/N 17268012 N75876Roe Amber · Scotts Valley, CABuilt 1976 · S/N 17268013 N75878Milosevich Nikola · Deland, FLBuilt 1976 · S/N 17268014 N75879Griffin Aviation LLC · Spokane, WABuilt 1976 · S/N 17268015 N7587RFca Flight Training LLC · Washington C H, OHS/N 28-22154 N7587WHawbaker Ray · Quinter, KSBuilt 1964 · S/N 28-1537 N75885Mds Enterprises LLC · Lemont Furnace, PABuilt 1976 · S/N 17268019 N7588CGrand Aviation Inc · Grove, OKBuilt 1975 · S/N 28-7625076 N7588PMyres Ronald W Trustee · Mckinney, TXBuilt 1961 · S/N 24-2799

Back to AD 80-04-03 R2