AD 2006-10-21
Registered aircraft · 44,908
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:2006-10-21')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21')
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:2006-10-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2006-10-21') 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.
N24018Schulte David L · State College, PAN24019Orr Stevan J · West Bloomfield, MIN2401AWhite Pat J · Wellington, TXN24026Albion-Edgerton Flyers Inc · Fort Atkinson, WIN24027Wilson Dwayne L · Arlington, TXN24028Weitzner Russell Scott · Virginia Beach, VAN24041Texas Flight Training Aircraft 8 LLC · Wilmington, DEN24055Shipley Larry W · Corsicana, TXN24057Macaluso Raymond A · Sweetwater, TNN2405MFree Flyers Avionics Inc · Kerkhoven, MNN2405SJohn L Lyle Aviation LLC · Ridgeland, MSN2407NPhoenix East Aviation LLC · Daytona Beach, FLN2409ENutac Leasing LLC · Deland, FLN240AAFf22 LLC · Scottsdale, AZN240AKPhoenix Leasing LLC · Menomonee Falls, WIFirst renewal noticeN240ARRiddell Orin · Coronado, CAN240AVPiper Aircraft Inc · Vero Beach, FLN240CTCoast Flight Training & Management Inc · San Diego, CAN240DCWestbank Fishing LLC · Kiln, MSN240DGGubert David A · Saint Johns, MIN240JAHot Wings Aviation LLC · Indianapolis, INN240JBMarking Kevin J · Omaha, NEN240KHBurns Shane H · Waxahachie, TXN240KTHarrelson Don E · Newnan, GAN240MASouthern Air Services LLC · Okeechobee, FLN240RG182rg LLC · Bellevue, WAN240RJHavabaaz Aviation LLC · Great Falls, VAN240SBPeacock Bradley B · Norco, CAN240SCPutt Larry F · Evans, GAN240SMDance Bruce B · Carthage, MON240SSStroup Robert L · New River, AZN240TFAir Fleet Holdings LLC · Missoula, MTN240UBoard Of Regents Of The University Of Oklahoma · Norman, OKN240WMSmith Alan D · Pacoima, CAN240WYRogers Richard A · Dallas, TXN24108Svetfur Aviation LLC · Camden, SCN2412RGagnon David D · New Market, ALN2412WWestern Edge Aviation LLC · Dickinson, NDN2413Gabardi Duane A · Manitou Springs, CON24139Averett University · Danville, VAN2413TRing Michael E · Lake Village, INN24144Edb Air Inc · Wilsonville, ORN2416MSun South Aviation LLC · Wilmington, DEN2417MRens Troy D · Marshfield, WIN2418RMann Steven · High Springs, FLN2418VHart William Kirby · Springville, CAN2419RLynch Gerald A · Santa Barbara, CAN241AFState Of Louisiana · Baton Rouge, LAN241ATAirline Transport Professionals Corp Of USA · Wilmington, DEN241BHughes Dustin G · Texarkana, TX
Back to AD 2006-10-21