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.
N388DEC4 Aviation LLC · Tulsa, OKN388DHCavu Pilot LLC · Powell, TNN388GWings And Wheels II LLC · Parker, CON388HMack Aviation LLC · Highlands Ranch, CON388KMJm Environmental Inc · Granite Bay, CAN388SPWeber Donald E · Saint David, AZN388STHappy Trails Capital LLC · Bainbridge Island, WAN3891WPhoenix Construction Services Inc · Lynn Haven, FLN3895GMike Kilo Aviation LLC · Garden Ridge, TXN389ARLifetime Aviation Services LLC · Muncie, INN389BS94k Aviation LLC · Wichita, KSN389CSSahi Carl R · Coventry, CTN389WMKairos Holdings LLC · Scottsboro, ALN38AUBraun Aviation LLC · Lakewood Village, TXN38AWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN38AZN731ny LLC · Phoenix, AZN38CJAirplane Seven LLC · Watkins, CON38CMSale Reported · Fay-Aux-LogesSale reportedN38DZWoolard Flying Service Inc · Corning, ARN38EPAircraft Guaranty Corp Trustee · Oklahoma City, OKN38GJMonahan Jeffrey L Trustee · Long Beach, CAN38GWAircraft Partner N38gw Dst · BerlinN38LPN38lp LLC · Jacksonville, FLN38LZJk Hangar LLC · Green Bay, WIN38MWWise Michael L · Lagrangeville, NYN38NTYorkavitz James B · Valley City, OHN38PFSycan Corp DBA · Paso Robles, CAN38PKDeininger Robert · Apopka, FLN38TLBonanza 1 LLC · Hernando, MSN38WPWjjb Aviation LLC · Fountain Hills, AZN3907GMid-America Sport Parachute Club · Taylorville, ILN390RSSchoene Edward C · Springfield Center, NYN3912PRegistered aircraftN391CPMkns 319cp LLC · Kalispell, MTN391PT7640 Drilling LLC · Amarillo, TXN3928BKellner Eric · Upland, CAN392MTOld School Consulting And Management LLC · Henderson, TXN3936GBaker George G · Junction City, ORN393DSRut N Strut Aviation LLC · Shelbyville, KYN393DW3 Delta Whiskey LLC · Superior, WIN393GMFly Illini LLC · Indianapolis, INN393JM3b Family LLC · Dover, DEN393PSVein C Jason · Riviera Beach, FLN394CPN394cp LLC · Pinehurst, NCN394JMHigh Steaks Aviation LLC · Ragley, LAN394MKTtc Travel LLC · Terre Haute, INN394SJFlinn Patrick R · Reeds Spring, MON394TAN4468n LLC · Cheyenne, WYN394WTMorgan Edmund Neal · San Diego, CAN39501Jw & Jl Aviation LLC · Phoenix, AZ
Back to AD 2012-10-13