AD 2012-10-52
Registered aircraft · 2,750
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-52')
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-52')
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-52') 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-52') 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.
N1715LValiair Limited Co Trustee · Casper, WYN1717XSay Plastics Inc · Jacksonville, TXN171BCR Wesley Aviation LLC · Chandler, AZN171RSSeneque USA Inc · West Palm Beach, FLN171TMG&L Aviation Services LLC · Las Vegas, NVN1727LTexas Department Of Public Safety · Austin, TXFirst renewal noticeN1728LCaldwell Clifton M · Sterling City, TXN1734UWing Nutz LLC · Pasadena, CAN17386Oregon State Police · Salem, ORN1740LMidsouth Marketing Inc · Colt, ARN1742XR&C Aviation Partners LLC · Tucson, AZN1746LNebraska State Patrol · Lincoln, NEN1747BDgpiper · Sheridan, WYN174STMichigan State Police · Lansing, MIN1756LSan Sophia LLC · West Linn, ORN1756URude Daniel R · Leesbug, VAN176CPCivil Air Patrol · Maxwell Afb, ALN1778UMission Aviation Fellowship · Nampa, IDN1782URbr Aircraft Inc · Albuquerque, NMN1786XS K Cattle Co · Manhattan, KSN178RDHelicopter Consultants Inc · Union, WAN179DMNg Research · Bristow, VAN179MEFlight Rt LLC · Thonotosassa, FLN17BBTextron Aviation Inc · Wichita, KSN180KHPwx Services · Bristow, VAN1812QLiv2fly LLC · Grand Junction, CON1815HPlane Fun Inc Tr Trustee · Snellville, GAN181MECoastal Marine Engine Inc · Seattle, WAN181PKPacific Mission Aviation · Hagatna, GUFirst renewal noticeN181TXAddie-Air Inc · Bridgeport, TXN18260Atc Trucking Inc · Miami, FLN1834UWirth Rodney A · Greenwood, ARN184SGNby Productions · Bristow, VAN185BKSfh Inc · Fargo, NDN185KPNg Research · Bristow, VAN18691869 Leasing LLC · Aurora, ORN186MLIdaho Fly Girl LLC · Boise, IDN187DHPsl Surveys · Bristow, VAN188AGRvest Management LLC · Boulder City, NVN188CSJaae Inc · North Miami Beach, FLN188SSNby Productions · Bristow, VAN189CBOtv Leasing · Bristow, VAN189JCTulare County Sheriff · Visalia, CAN189JMJsc Rentals LLC · Missoula, MTN190PDCommonwealth Of Puerto Rico Policia Of Puerto Rico · San Juan, PRN191MBFvx Research · Bristow, VAN1922TBiscoe Donald M · Cottage Grove, MNN192CMFriehe Berend · Moses Lake, WAN192WBPsl Surveys · Bristow, VAN193GMRkt Productions · Bristow, VA
Back to AD 2012-10-52