AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13')
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:2012-10-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-10-13') 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.
N36GWSky Whiddon Inc · Fort Lauderdale, FLN36HCSimply Everything LLC · Greer, SCN36HPNyack Inc · Emigrant Gap, CAN36HWHw Inc · Omaha, NEN36JHFlowerree Farms Inc · Bend, ORN36KBCrumley Michael B · Anchorage, AKN36KPAir Lease Inc · Bridgeport, WVN36LLBeech Bums Aviation II LLC · Linden, MIN36LMN36lm LLC · Spicewood, TXN36LRQuarter Circle E Enterprises Inc · Yorba Linda, CAN36MNKad Enterprises LLC · Everett, WAN36MRCook Canyon (Gp) LLC · Dallas, TXN36MWM & A Aircraft LLC · Missoula, MTN36NCrossman Kyle D · Monroe, MIN36NBCl Holdings LLC · Washington, DCN36NMFrost Cavin Bert · Odessa, TXN36PDHigh Flyers LLC · San Luis Obispo, CAN36PKGoodman Ronald · Dos Palos, CAN36PVLong Wing Aviation LLC · Houston, TXN36PYMoore Gary E · Crossville, TNN36PZFillips Robert Victor · Alvin, TXN36RWBas Part Sales LLC · Greeley, CON36SValaco Inc · Albertville, ALN36SATango Whiskey Holdings LLC · Moorpark, CAN36TEGary Vaughan Construction Inc · Leland, MSN36TKKinsey & Co Inc · Las Vegas, NVN36TMPendragon LLC · Stuart, FLN36TRClark Tj · Saint George, UTN36VMTri-Rivers Enterprise · Cameron, MON36VTTurley Ty P · Ramona, CAN36VUThomas Gary F · Mount Shasta, CAN36XArchangel Aviation LLC · Cleburne, TXN36XGWhite Doug · Torrington, WYN36YBGrey Fox Corp · La Canada Flt, CAN36YMRankay Air LLC · Sanger, CAN36YPVillages Equipment Co · Leesburg, FLN3701NGreat Lakes Aero Marine LLC · Green Bay, WIN3704GGap Holdings LLC · Dover, DEN3708KWard Ron · Oklahoma City, OKN370BMChad Davison Insurance Agency Inc · Bend, ORN370GAir Land Ventures LLC · Highland Park, ILN370JGGuideair LLC · Eden Prairie, MNN370JR110 Aviation LLC · West Des Moines, IAN37126Robison Charles T · Pierre, SDN3714ZQuick Foam Insulation LLC · Lubbock, TXN37181Jrs Aviation LLC · Falls City, NEN371BBLake Peipsi LLC · Williamstown, WVN371BGCzok Justin · Park Ridge, ILN371CDEicholz Robert Trustee · Palm Springs, CAN371ECNext1sr LLC · Dayton, OH
Back to AD 2012-10-13