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.
N997AVOlioni Aviation LLC · Palo Alto, CAN997CDN997cd Corp Trustee · Wilmington, DEN997CHHolly Ridge Planting · Indianola, MSN997JDAviation.One Business Holdings LLC · Mesa, AZN997JKEastern Stearman Inc Trustee · Leesburg, VAN997PSFuel X LLC · Pearl, MSN997RRegistered aircraftN997TAAir Flight Inc · Fort Lauderdale, FLFirst renewal noticeN997TCJasmine Aviation LLC · Los Altos, CAN9982YChin-Loy Christopher Wayne Trustee · Tamarac, FLN9983MTate Clint · Boise, IDN9984GIndura Air Holdings LLC · Bloomfield Hills, MIN9986MLogan Timothy R · Valley City, NDN9989Bank Of Utah Trustee · Salt Lake City, UTN998CDLindsay Allan · Papillion, NEN998CZMesa Aviation LLC · Mesa, AZN998DFThompson William III · Lawrenceville, ILN998EKAopa Foundation Inc · Frederick, MDN998JA2 Doods LLC · Lakewood Ranch, FLN998JGDragonfly Aviation LLC · Davie, FLN998JWBowtie Investments LLC · Schriever, LAN998KBPure Air LLC · Wichita, KSN998LSTalton Rentals LLC · Tupelo, MSN998PMWirth Aviation LLC · Scottsdale, AZN998PRRanchlands Management Company LLC · Las Vegas, NVN998RCCf Holdings LLC · Hernando, MSN998WTMkeair LLC · Waukesha, WIN9991Sale Reported · Kalispell, MTSale reported, canceledN9991YArwlb Aviation LLC · Spokane, WAN9994Holstein Group Inc · Lomita, CAN9996JDiamond X LLC · Elko, NVN999AJNedley Aviation LLC · Wilmington, DEFirst renewal noticeN999ANOsi Air LLC · Wilmington, DEN999AVSouza Engineering Contracting Inc · San Luis Obispo, CAN999BFRigel Aviation Inc · Jefferson Hills, PAN999BYBrace Yourself Orthodontics Inc · Portsmouth, OHN999CECb Wings LLC · Eugene, ORN999DCTbm Avenger Inc · Peru, ILN999DXJourneyman Aviation LLC · Louisville, KYN999EBEngines Inc · Jonesboro, ARN999ETJet Aero LLC · Montoursville, PAN999FAFlying Affair LLC · Jupiter, FLN999JLFlying Swan LLC · Ashland, NHN999JWWazney Aviation LLC · Willoughby, OHN999KMMaule Aviation LLC · Las Vegas, NVN999KSColumbia Asset Trust Corp Trustee · Wichita, KSN999LCJust Plane Aviation LLC · Baldwin, MIN999PCFlying T LLC · Albuquerque, NMN999PGRegistered aircraftN999RKTcg Aviation LLC · Pelham, AL
Back to AD 2012-10-13