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.
N383JMRegistered aircraftN383PLambe Clarence Jr · Kernersville, NCN383SA86 Malibu LLC · Fort Worth, TXN383SRCoscia Joseph R · Granite Bay, CAN383TTWestwood Aircraft LLC · Asheville, NCN383WHCirrus Design Corp · Duluth, MNN383WTAviation Corporation Inc · Reno, NVN3840YBurrill Resources Inc · Medford, ORN3842UBezet Danny · Comfort, TXN3842YCole Scott A · Rockford, MIN3843SSky West Aviation Inc Trustee · Albuquerque, NMN3848YBaron Lake LLC · Jefferson, LAN384DEDestinations Efc LLC · Tulsa, OKN384SRRegistered aircraftN384WPlum Aviation LLC · San Diego, CAN384WSJag Aviation LLC · San Francisco, CAN3850GN3850g LLC · Stamford, CTN3851CAbb Aviation LLC · Burnsville, MNN3854GDry Creek Aviation LLC · Belmont, CAN385ASCoraggio Joe · Chandler, AZN385BLBurghard Properties LLC · Ponte Vedra Beach, FLN385CFoster Harry A · Birmingham, ALN385CAHyannis Air Service Inc · Hyannis, MAN385NTBanks Todd M Trustee · Pauma Valley, CAN385PTPthc Avion Inc · Sierra Vista, AZN385RAdvanced Technology Distributors Inc · Ceres, CAN385SRMcmonigle And Associates LLC · Washington, DCN385TWSheely Patrick D Trustee · Rapid City, SDN3862PBrown Travis Trustee · Columbia, MON3862RToco Inc · Healdsburg, CAN3864UInterrail Power Inc · Jacksonville, FLN3869SPeterson Kurtley D · Gunnison, UTN386AMAdvocate Air LLC · North Logan, UTN386CKRiggs Russell · Sedalia, CON386DEDestinations Efc LLC · Tulsa, OKN386DMFantini Michael A · Sayre, PAN386GTab Holdings LLC · Fort Dodge, IAN386RRProspective Management LLC · Ann Arbor, MIN3872W6 Chicks Aviation LLC · Santa Maria, CAN387ABRegistered aircraftN387APDynamic Management LLC · Sharpsburg, GAN387J387j LLC · Scotts Hill, TNN387JRThree Eight Seven Jr LLC · Sunray, TXN387LRWoodruff Howard G · Goodyear, AZN387SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN387TXPeterson Shawn M · Scottsdale, AZN3885GRichland Aviation Inc · Sidney, MTN3886PUncanny Valley Films Inc · Arroyo Seco, NMN388APSch Aviation Inc Trustee · Sporle Kings LynnN388CPKountry Air Aviation LLC · Montgomery, IN
Back to AD 2012-10-13