AD 84-09-07
Registered aircraft · 569
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:84-09-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-09-07')
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:84-09-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:84-09-07') 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.
N1010KCooley Joshua · Kenai, AKN10157Kuber Daniel S · Girdwood, AKN102MDFarrington Kelly · Sisters, ORN103GSDuce Phillip N · Kotzebue, AKN10SYBellany Mark A · Freeville, NYN11101Perin Jeffrey S · Wasilla, AKN12008Dvoracek Dana J · Charlevoix, MIN12009Jordan Ronald W · Stoutsville, OHN12011Marsh John Edward · Washington, DCN12014Thompson Robert J · Kaktovik, AKN12015Thurmond Paul J · Huntley, MTN12016Swain Michael J · Jacksonville, FLN12017Nuckles Charles Austin Jr · Suffolk, VAN12018Theriot Harris J Jr · Thibodaux, LAN12026Bernhardt Michael J · North Branch, MNN12027Rugland Roger E · Anoka, MNN12029Dippold Lois M · Perry, MIN12031Burnett Brandon Ryan · White Lake, MIN12032Riebe Robert D · Caldwell, IDN120AGHallmark Ronald D · Spring Hill, TNN124CHSpearhead Aviation Inc · Parker, CON12BEElliott Russell R · Wasilla, AKN141AREpp Robert Jackson · New Kent, VAN143JDHarris Steven V · Springtown, TXN14LMFeuerborn Ethan · Boise, IDN155BHRyan John P · Kankakee, ILN164BMMachtemes Brian A · Minnetonka, MNN166RWGrasshopper Aviation LLC · Betsy Layne, KYN169WWPro Aire Inc · Chisago City, MNN171GSMccormick Gregory W · Athens, ALN18PRDenicola Frank · Visalia, CAN1900ZChavey Gary G · Manchester, MIN19SDMckenney Bret K · Billings, MTN19WXSale Reported · Alex, OKSale reportedN2001UWest Coast Resources Inc · Anchorage, AKN2010USkydotcom LLC · Inver Grove Hgts, MNN2012UZimlich Kaylee M · Fort Collins, CON2013UBenedict Michael T · Anchorage, AKN2020UGrant James L · Cameron Park, CAN2022USutton Aircraft Salvage LLC · Palmer, AKN2023URegistration Pending · Belton, TXRegistration pendingN2024UAlaska Wing Covers LLC · Wasilla, AKN2028UFisher Jeffrey L · Thorndale, TXN2029USmith Thomas A Trustee · Rogersville, ALN2030UStandridge Dan J · Milpitas, CAN2032UMerrell Jared E · Wasilla, AKN2039UElison Tad · Hagerman, IDN2049UCarlson Kent V · Jacobson, MNN2050UAnderson Daniel A · Overly, NDN2051UHood River Aviation LLC · Hood River, OR
Back to AD 84-09-07