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.
N87RJNorris Aviation LLC · Mansfield, TXN87RRBahnair LLC · Oklahoma City, OKN87SM10269 Flight LLC · Bainbridge Island, WAN87TUThree Eagles LLC · Kalispell, MTN87URElemet Equipment Leasing LLC · Camden, DEN8801GAviation Trust Co LLC Trustee · Oklahoma City, OKN880AMj Aviation LLC · Denham Springs, LAN880CDAl Batross Air LLC · Guntersville, ALN880MSSkylane Cirrus LLC · Sarasota, FLN8817MUniversal Aircraft Holdings LLC · Waterford, MIN8818MCapitol Flyers LLC · Jefferson City, MON881CHl Air LLC · Scottsdale, AZN881CAPechts Contracting LLC · Church Road, VAN881JVVoss James S · Boulder, CON881PGPlane Pro Aviation LLC · Shelby, NCN881PJJohnson Patrick Allen · Olive Branch, MSN881PMG5 Partners LLC · Reno, NVN881RTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN881SRCjc Design Inc · Yorba Linda, CAN881TCBrait Aviation LLC · Edina, MNN881TJBarron Eddie T · Amarillo, TXN881WCSale Reported · Gainesville, FLSale reportedN881WD306kc LLC · Hockley, TXN881XPKusenberger Don L · Little Rock, ARN8822G22g LLC · San Jose, CAN8823HBowers Phillip P · Clayton, NCN882BCTechnology Aviation Services LLC · Covington, GAN882CJkz Properties LLC · Port Orange, FLN882CDRegistered aircraftN882CTCharlie Tango Aviation LLC · Rocklin, CAN882SL882 Aviation Inc · Tarrytown, NYN882SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN882WBWright Bros Flying Club LLC · Lewes, DEN8837ZPepple Tom · Medford, ORN883CBBraly Capital Management LLC · Seal Beach, CAN883ELEcho Lima LLC · Irvine, CAN883ESAustin J Ma M D Pc · Los Angeles, CAN883JPGemis Paul · Nantucket, MAN883TFWhamola Inc · San Rafael, CAN884Patronus Wings LLC · Scottsdale, AZN884CN884c LLC · Georgetown, SCN884CDBcd Aviation LLC · Waleska, GAN884LMVc Travel LLC · Fairport, NYN884SRBt Aviation LLC · Monclova, OHN884SWMountain Lion Aviation LLC · Truckee, CAN884TLT Lo Airways LLC · Mesquite, TXN8851KJac Leasing LLC · Fort Myers, FLN8851LHong Yun Ji LLC · Traverse City, MIN88521Godfrey Pharis · Missouri City, TXN8853K8853k LLC · New Bedford, MA
Back to AD 2012-10-13