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.
N999SJInfinity Commercial And Industrial Concrete LLC · New Braunfels, TXN999SKWkqm LLC · Wilmington, DEN999TFSpencer Brett · Kila, MTN999XGL&W Holdings And Trust Inc · North Fort Myers, FLN99BYAirria Holdings LLC · BerlinN99CDPapa'S Hatchn Enterprises Inc · Wilmington, DEN99CPEight One Whiskey LLC · Orinda, CAN99CWSurf & Summit Aviation LLC · Jupiter, FLN99GWWatson Green Energy LLC · Alamogordo, NMN99HJMf Property Management LLC · Hattiesburg, MSN99HSSpecialty Stainless Installations Inc · Chino, CAN99JTNunavat Aviation LLC · Edmond, OKN99JZUnadventurous LLC · Amarillo, TXN99KESedrak Michael · Corona, CAN99MSLubell Daniel R · Bothell, WAN99MUGooney Aviation LLC · Camden, DEN99PAMckelvey Jeffrey R · Dadeville, ALN99PYR&R 22t2 LLC · Wilmington, DEN99RKNorth Shore Flying Club · Libertyville, ILN99SL99sl LLC · Boston, MAN99TDAviation Trust Company LLC Trustee · Oklahoma City, OKN99UK99 Air Inc Trustee · Wilmington, DEN99UWTaz Aviation LLC · Middleton, WIN99VBC&S Aviation Partners LLC · Thibodaux, LAN99VMDaniel M Skotte Do Pc · Sunriver, ORN99WWu Lei · San Marino, CAN99WTSudick Daniel · Dadeville, ALN99XLSeawind LLC · Newport, RIN99YZEdwal Aviation LLC · Reno, NVN99ZDAir Helmuth LLC · Statesville, NCN9AWRegistered aircraftN9BHBeh Aviation Group LLC · Port Matilda, PAN9DMMaloney Leasing LLC · Tupelo, MSN9DVNorwood Ronald Steven · Raleigh, NCN9EPMcavian LLC · Perryton, TXN9GFApruda Andri Trustee · Nashville, TNN9JBRgpe Consulting LLC · Wilmington, DEN9JRBringle Cory · North Liberty, IAN9LSAmsprop USA Holding Inc · Boca Raton, FLN9LTRegistered aircraftN9MPYen Albert S · Hermosa Beach, CAN9MWPoint Of Rocks LLC · Lakewood Ranch, FLN9NCEmpresas Marex Inc · Mayaguez, PRN9NSTs&L Aircraft LLC · Alexandria, MNN9PJAircraft Guaranty Corp Trustee · Oklahoma City, OKN9RYDpr Capital LLC · Farmington, UTN9SHSenza Limiti LLC · Park City, UTN9SZAircraft Guaranty Corp Trustee · Oklahoma City, OKN9TFBender Glenn Steven · Lovell, MEN9TRSky West Aviation Inc Trustee · Albuquerque, NM
Back to AD 2012-10-13