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.
N88549Seed Richard J IV · Holmes Beach, FLN88555Iverson Douglas B · Sammamish, WAN8855MHorizon Marine LLC · Lake Havasu City, AZN8856KHerrmann Alan J · Laguna Niguel, CAN8857KBall Bearing Aviation LLC · Lowell, ARN885AAMachen36 LLC · Dover, DEN885EWHulxe Construction Services LLC · Mesa, AZN885PTMouret Ralph Herbert · Houston, TXN885SRAircraft Guaranty Corp Trustee · Oklahoma City, OKN886ALHogue James B · Spencer, TNN886BATerzo Richard E · Lake Zurich, ILN886JRegistered aircraftN886JMMaidan LLC · Portland, ORN886KHLexi Air LLC · Boise, IDN886MLMichael Lam Md Apc · Los Altos Hills, CAN886SRRedfern Richard Wilder · Austin, TXN8870LBarker William H · Gulf Breeze, FLN8878THigh Power Logistics LLC · Louisville, KYN887KCKilo Charlie Holdings LLC · Lenexa, KSN887SAMcc Aircraft LLC · Rochester, MAN887SWSierra LLC · Collinsville, MSN887WQuad City Area Flying Eagles Inc · Milan, ILN8888PLear Gary M · Montrose, CON888AFAerospace Trust Management LLC Trustee · Wilmington, DEN888AJFaraci Nick G · New York, NYN888AKElliott David B · Dallas, TXN888BPXyz1234 LLC · Addison, TXN888CAInternational Air Services Inc Trustee · Carson City, NVN888CDTrue Steel Inc · Ada, OKN888DNTravelsafely LLC · Columbia, MDN888EAAustin E H Jr · San Antonio, TXN888ECArrow Aviation LLC · Noblesville, INN888EDGolden Eagle Express LLC · Dodge City, KSFirst renewal noticeN888EPValiair Lc Trustee · Casper, WYN888HFFlight1 Hsw LLC · Norwood, CON888HLPermian Basin Blue Sky Inc · Odessa, TXN888JVPatriot Management Company Inc · Donnelly, IDN888JWRedd Brand Aviation LLC · Twin Falls, IDN888KBAarons Plumbing LLC · Grand Ledge, MIN888KPRunway 321 LLC · Hilton Head Island, SCN888LVAllies Aviation LLC · Fort Walton Beach, FLN888MBsa Vending · Rohnert Park, CAN888MTSpelts Mark Warren Trustee · Chico, CAN888MZM-Z Aviation LLC · Birmingham, ALN888NNorman James R · San Diego, CAN888PJPatterson Edward · Midland, TXN888REDill Harry H Trustee · Mebane, NCN888SALyman Joseph Scott · Kimberly, IDN888SGBlairwood LLC · Akron, OHN888SSRegistration Pending · Houston, TXRegistration pending
Back to AD 2012-10-13