AD 2002-17-53
Registered aircraft · 6,266
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:2002-17-53')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-17-53')
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:2002-17-53') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-17-53') 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.
N14036Booth Donald V · Denison, TXN14040Island Aviation Inc Trustee · Wilmington, DEN1404YDavidson Bill · Lewisville, TXN14051Sams Way · Eagle Mountain, UTN1409XHolmberg Shane A · Fairbanks, AKN140DCCheely Matthew G · Hillsdale, MIN140HPCalifornia Highway Patrol · Sacramento, CAN140RDAlpha Whiskey 3 LLC · Brandon, MSN140RMMckenzie Michael C · Ventura, CAN140TAGuggenair LLC · Carbondale, CON14133C I Holdings Ltd Inc · Lewes, DEN14138Island Bound LLC · Dunedin, FLN14149Ninja Turtle LLC · Orlando, FLN1419XWhitman Aviation LLC · Morganville, NJN141MEFox Heather J · Bettles Field, AKN141SBCk Aviation LLC · Bismarck, NDN14202Hodge Uriel · St Thomas, VIN14207Belk William E · Labelle, FLN1421KFjb Flyers LLC · Scottsdale, AZN14221Hilltop Growers LLC · Oceano, CAN14224Townley William V · Weirsdale, FLN14229Holt Bryan J · Flowery Branch, GAN14243Blitz Daniel R · Corsicana, TXN14244Pacific Fleet Aviation LLC · Rochester, NYN1424NEbonaster Enterprises LLC · Slidell, LAN14252Caja Aviation LLC · Cheyenne, WYN1425AVan Bortel Aircraft Inc · Arlington, TXN14268Kilgore Garrett M · Whitwell, TNN1426SBoundless LLC · Dakota Dunes, SDN14306Orkiszewski Jerzy · Scottsdale, AZN14350Pema Aviation LLC · Tavernier, FLN1435TWaters Nicholas T · Claypool, INN14368Semeniuk Steven T · Houston, TXN14379Bas Part Sales LLC · Greeley, CON1437RMcis Aviation LLC · Wilmington, DEN14386Blue Star Aviation Services LLC · Shippensburg, PAN1438TFreedom Flyers II LLC · Islip, NYN14394Pavco Inc · Gig Harbor, WAN143ACPotcake Aviation LLC · Missoula, MTN143GBDocinator Aviation LLC · Edmond, OKN143KYClark Michael B · Montgomery, TXN143LAMontana Aircraft Trust Inc Trustee · Bozeman, MTN143PPBolch James R · Vero Beach, FLN14401Berggren Ryan · Newton, NJN1445HNelson Joshua M · Eagle, IDN144ASValiair Lc Trustee · Casper, WYN144EBCavu Aviation LLC · Noblesville, INN144HPButler Christopher E · Fort Lauderdale, FLN14510Bates Russell L III · Norman, OKN14513Owens Kevin · Georgetown, TX
Back to AD 2002-17-53