AD 68-07-08
Registered aircraft · 196
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:68-07-08')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:68-07-08')
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:68-07-08') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:68-07-08') 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, ORN12008Dvoracek 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, IDN124CHSpearhead Aviation Inc · Parker, CON164BMMachtemes Brian A · Minnetonka, MNN169WWPro Aire Inc · Chisago City, MNN19WXSale 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, TXN2030UStandridge Dan J · Milpitas, CAN2032UMerrell Jared E · Wasilla, AKN2039UElison Tad · Hagerman, IDN2049UCarlson Kent V · Jacobson, MNN2050UAnderson Daniel A · Overly, NDN2051UHood River Aviation LLC · Hood River, ORN2054UMerrell Jared E · Wasilla, AKN2056UKw Group LLC · Philipsburg, MTN2065UKohler Richard L · Moriarty, NMN2066UFletcher John G · Diamondhead, MSN2069UBaucom Thomas A · Midland, NCN2074UObannon Jack Jr · Houston, TXN2077UUnertl Ronald W · Waupaca, WIN207KMWayt Kevin D · Ladera Ranch, CAN220PMFarmer Daniel L · Colorado Springs, CON264HUSpearhead Aviation Inc · Parker, CON27HMMaccarone Mario R · Wasilla, AKN29PPBevis Thomas L · Sebring, FLN324BAHart John Michael · Olalla, WAN32DLLarson David W · Palmer, AKN380QThomas George E · Rice, WA
Back to AD 68-07-08