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.
N6675ATool Equipment Leasing Corporation · Bethany, OKN6675YField Inspection LLC · Brawley, CAN6677BHess Chad · Boise, IDN6677LAeropacific Consulting LLC · Reno, NVN6677RTre Aviation Corp · Wilmington, DEN66784Grimm Phillip H · Draper, UTN6678C678c LLC · Pensacola Beach, FLN6678YNewhouse Eric · Corrales, NMN6679YRanchlands LLC · Hyattville, WYN667CDCirrus Aircraft Shares Inc · Williamsburg, VAN667CWRegistered aircraftN667PCMattie Joseph · Ester, AKN667SRN667sr LLC · Richmond, KYN667WGCirrus Design Corp · Duluth, MNN6680BBush Douglas B · Santa Rosa Beach, FLN6680GHorst Commercial Ventures LLC · Sanger, TXN6683NLn Skies LLC · Streetman, TXN6683YGate Post Aviation LLC · Woodbury, CTN66844Munden Paul M · Amarillo, TXN6686NClarity Aviation LLC · Anchorage, AKN6687DVolare Flight Service LLC · Pine Village, INN66885Turn Key Construction Services Inc · Lincoln, CAN6688NLedson Steven Noble · Sonoma, CAN6688YHolt Kyle · Cottontown, TNN668DESteele Kevin · Phoenix, AZN668JGCapps Steven M · Mount Pleasant, TXN668RSRs 238 LLC · Long Beach, NYN668SRLatitude Aviation LLC · Huntingdon Valley, PAN6692RToga LLC · Scottsdale, AZN6694NGear Down LLC · Dalhart, TXN6696ZMonahans Affordable Homes LLC · Monahans, TXN669BFForce Aviation LLC · Indiana, PAN669CDNo Fear Services LLC · Madison, WIN669GLG-Loft Aviation LLC · Rapid City, SDN669JMMerrell Bros Aviation LLC · Kokomo, INN669LKKiewiet Enterprises Inc · Buffalo Center, IAN669MAN669ma Inc Trustee · Wilmington, DEN66BLLemon Bryant William Jr · Albuquerque, NMN66CEM&S Real Estate Management Inc · Granbury, TXN66CZCollins Aviaiton LLC · Daytona Beach, FLN66DFClark Samuel D Trustee · Wilson, WYN66ELSutter Ernest · The Woodlands, TXN66FVector Victor LLC · San Carlos, CAN66FSPayne Air LLC · Gulf Breeze, FLN66HGHg Aviation Inc Trustee · Wilmington, DEN66JEUer LLC · Searcy, ARN66LAAviary LLC · Greer, SCN66LHLane Law Firm Pc · Greenwood Village, CON66LJ66lj Flying LLC · Wilmington, DEN66MLBas Part Sales LLC · Greeley, CO
Back to AD 2012-10-13