AD 79-10-14 R1
Registered aircraft · 56,582
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
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.
N764SPColonial Air Inc · New Bedford, MAN7651AMonson Conrad J · Wasilla, AKN7651XHappy Landings Aviation LLC · Maple, NCN7652AWilliams Jerry B · Vashon, WAN7652MHenderson Aviation LLC · Norman, OKN7654KLuginbuel Stacy W · Prairie Grove, ARN7654LLarsen Daniel R · Kenai, AKN7654VRene Ronald M · Linden, NCN7655TMorrell Nathaniel A · Pelham, GAN7655USitta Donald C · Farmington, NMN7655XMedical Surgical Clinic LLC · Fort Scott, KSN7656MSparrowhawk Aviation · Manvel, TXFirst renewal noticeN7656XMiranda Maria J · Santa Maria, CAN7657GDodd Brian G · Mount Vernon, SDN7657TGuarno Adam C · Milton, FLN7657XGordon Christopher R · Moose Pass, AKN7658AWest Michigan Aviation Inc · Kalamazoo, MIN7658URegistration Pending · Oregon City, ORRegistration pendingN7659TKano Yoshio W · Barrington, ILN765MJBusch Renard · Castro Valley, CAN765SATextron Aviation Inc · Wichita, KSN765SRRichard Stephen R · Delphos, KSN7660GKorn Clifton A · Hayward, WIN7660XAdams John S · Roselle, ILN7661AMiller Bradley · Joliet, MTN7661MPaul Gregory A · Overland Park, KSN7661USweitzer Cameron D · Warrensburg, MON7662GB&R Aircraft LLC · Wadsworth, OHN7662KBredthauer Glen · Hastings, NEN7662TTriana David · Goose Creek, SCN7662UMcintyre James C · Bethlehem, PAN7663ATovsen John T · Anchorage, AKN7663MRashid Shahn S · Clear, AKN7663TTc Flight LLC · Lincoln, NEN7664MMalinchak Louis Jr · Bristow, OKN7665UGazca Aaron Armando · Burgaw, NCN7665XAvz Aviation.Inc · Knoxville, TNN7666ACournoyer Constance L · Ellsinore, MON7666GHudson Daryl J · Redwood Valley, CAN7666XSidaras Al · Salado, TXN7667GBrooks Alan G · Kernersville, NCN7667MGier James C · Belgrade, MTN7667THembree Roy C Jr · Covington, GAN7667XMatthews Thomas A · Belvidere, NJN7668ASpevacek William E · Geraldine, MTN7668KAviation Enterprises Aircraft Sales LLC · Springfield, MON7668MNeal Daniel L · Morgan Hill, CAN7668THoff Stephen R · Wilson, WYN7668UMarchbanks William W · Hillsboro, ORN7668XEkerberg Mark J · Newton, KS
Back to AD 79-10-14 R1