Skip to content

Registered aircraft · 40,394

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

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 N7588WRustic Getaways LLC · Eagar, AZBuilt 1964 · S/N 28-1538 N75890Milligan Tony L · Rumford, MEBuilt 1976 · S/N 17268020 N75897Gopalakrishnan Sanjeev K · Spring, TXBuilt 1976 · S/N 17268023 N75898Center O Flying Club · Tumwater, WABuilt 1976 · S/N 17268024

Back to AD 79-10-03 R2