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.
N60MKAircraft Guaranty Corp Trustee · Oklahoma City, OKN60PKWexcap Leasing LLC · Centerville, UTN60PPJaams LLC · Shafter, CAN60PZRbj Tn Holdings LLC · Sheridan, WYN60RSVolare Alto LLC · Sanford, NCN60SHBas Part Sales LLC · Greeley, CON60UHSecret Destinations LLC · Gretna, LAN60WHSan Clemente David Paul · Edgewater, FLN6100YRamsay Allan Trustee · Modesto, CAN6102WPlane Blessings LLC · Montrose, CON6103YQualitair LLC Trustee · MichelstadtN6105XKramer James W Jr · Eynon, PAN6106CB & S Aviation Enterprises LLC · Atlantic Beach, FLN6107QKk Equipment Leasing LLC · Seguin, TXN6109RBas Part Sales LLC · Greeley, CON610CDChalin Flight Services LLC · Wilmington, DEN610CFCarbon Air LLC · Cypress, TXN610GBSierra Zulu Aircraft Holdings LLC · Lake Elmo, MNFirst renewal noticeN610KCU S Imaging Flight Ops LLC · Bartow, FLN610PPPoolside Aviation LLC · Pottstown, PAN6112ABarreto Manufacturing Inc · La Grande, ORN6116NWalker Stephen · Fairhope, ALN61170Rusty Pilot Holdings LLC · Citrus Heights, CAN6119ABrender Ronald F Trustee · West Lafayette, INN611AWLess Swelling Equals Less Pain LLC · Brewerton, NYN611CCTjc Productions LLC · Ogden, UTN611CDPj Aviation LLC · Lake Worth, FLN611CTBrown Jed A · Laredo, TXN611ESGs Flying Club LLC · Bethlehem, PAN611KFRegistered aircraftN611KGProckter Aviation LLC · Lagrangeville, NYN611PGWrightson Properties LLC · Ft Lauderdale, FLN611PMYankaitis Michael J · Mosinee, WIN611RAH & K Acquisitions LLC · Peoria, AZN611RJRj 400 LLC · Iowa City, IAN611RMRm Management Corp · Johnson City, TNN611RPParish Oil Co Inc · Columbia City, INFirst renewal noticeN611RTGrutza Robert J · Maysville, KYN611VRRex Vinod · Sunnyvale, CAN611WBDelicious Epiphany LLC · Fort Wayne, INN611WSFreedom Flight Service LLC · Glendale, AZN6121XCrawford Products Co Inc · Huntington Beach, CAN6126CM20k LLC · Minot, NDN6126YCruise Flight Aviation Inc · Denver, CON61275K & K Adventures Inc · Wilmington, DEN612CTGl One LLC · Ankeny, IAN612EZCsc Delaware Trust Co Trustee · Wilmington, DEN612JJDelaware Aircraft Trust Trustee · New Castle, DEN612JMPerformance Aviation LLC · Zionsville, INN612JRQ & A Company LLC · Newport, RI
Back to AD 2012-10-13