AD 2012-16-13
Registered aircraft · 735
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-16-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-16-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-16-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-16-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.
N100DTTurner Daniel H · Sparks, NVN1018GSale Reported · Scandia, KSSale reported, canceledN102TGAvocation Aviation LLC · Findlay, OHN103ESouthtec Inc · Wilmington, DEN104AJPosav Holdings LLC · Zephyrhills, FLN105BPCassens Eric · Coopersville, MIN106PVJensen Douglas R · Mesa, AZN106SEPotter Julianne M · Rimrock, AZN1078Sentinel Air LLC · Walterboro, SCN107ERAguila Rosario Jimmy A · Carolina, PRN107HJLott John R · Andersonville, GAN107PGGoodman James A · Highland Park, ILN10ZGReeves Air Glide LLC · Moriarty, NMN111BTPestana Joseph P · Langlois, ORN111FACharrier Michael J · Hessmer, LAN111LYWatkins Jonathan Trustee · Florence, ORN112ETTrue Eddie M · Yelm, WAN113CGTreeline Inc · Lincoln, MEN1162PDrumheller Enterprises Inc · Kirkwood, PAN116CHEchols Randall J · North Pole, AKN116VASky High Aviation LLC · Arkadelphia, ARN118JWWheaton Jonathan B · Alexander, MEN119AMLight Sport Works LLC · Deland, FLN11HLAv8me LLC · Spicewood, TXN120TLHarrison Richard R · Sacramento, CAN1213HBoyle Steven J · Largo, FLN121FUMalir Richard E · Powell, OHN121WHQualitair LLC Trustee · MichelstadtN122CZChaz Air Cam LLC · Wellington, FLN123JGMullins Steve D · Springfield, MON123WHCox James Lee · Danville, ILN123YZFleisher Paul · Santa Monica, CAN1248Johnstone Terry D · Scottsdale, AZN124FAFirst Airborne LLC · Cocoa, FLN1252SFlying Felix One LLC · Chicago, ILN126ZXStockwell Robert L · New Harmony, UTN128BMEpic Aviation Inc · Denison, TXN129RRSteadfast Entities LLC · Philadelphia, PAN12CEChazoo Air Inc · Miami, FLN130PSSpackman E Paul · Casper, WYN130TVVincent Terry K · Greenville, KYN1345GRegistered aircraftN1386YHannigan Robert V · Gifford, WAN139CTGrandinetti Robert L · Fayetteville, NYN139SESahni Irvin K · Seguin, TXN141YRowland Richard · Hondo, TXN143AATorres Vincent Jimenez · Auburndale, FLN1447WRegistered aircraftN1461FSirmon James A · Daphne, ALN1469HSinnott-Simonis Lyle · Girdwood, AK
Back to AD 2012-16-13