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.
N6428ZDv Aviation Inc · Brainerd, MNN642CA110 Aviation LLC · West Des Moines, IAN642CDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN642CPDodson International Parts Inc · Rantoul, KSN642DSJgm Aviation LLC · The Woodlands, TXN642MMStar Tampa LLC · Indian Rocks Beach, FLN642SRSafford Robert Owen Jr · Clarksville, TNN642TLBuddy Air LLC · West Bend, WIN6431NMorton Craig Allister · Toluca Lake, CAN6431PHhd Aviation LLC · Hamilton, OHN6433XRand Carl · Durango, CON6436BConway Jenna M · Camarillo, CAN6439NSpectraq LLC · Las Vegas, NVN643JMSherman Aviation LLC · Haslett, MIN643SRSky Dawgs LLC · Kennesaw, GAN643TFFlyway Aviation Partners LLC · Rogers, ARN643UFRegistered aircraftN-number assigned (import), not yet registeredN643WMBarham Investments LLC · Dexter, MON6440BWolfe Transportation Inc · Meridian, IDN6440YTamarack Graphics LLC · Salt Lake City, UTN6442YPouppeville LLC · Tulsa, OKN6443NEwers Richard G · Indio, CAN6444CNichols Christian Travis · Rio Rancho, NMN6444WBas Part Sales LLC · Greeley, CON6445YRomero Bernard L · Santa Fe, NMN6446WRichter Aviation Inc · Maxwell, CAN6447ACouch Andrew W · Newport Beach, CAN6447XSteller Air Service LLC · Homer, AKN6449HN6449h LLC · Pompano Beach, FLN6449NBaumann Richard A Trustee · Tempe, AZN644BLGahan Matthew · San Clemente, CAN644CDKapp LLC · Dallas, TXN644HLAndaman Aviation LLC · Brewster, NYN644LBMdka LLC · Fort Mill, SCN644SRBas Part Sales LLC · Greeley, CON644STCohen Steven B · Safety Harbor, FLN644VCElder Daniel R · Kalispell, MTN6450YAttica Flyers Inc · Lafayette, INN6453CSale Reported · Miller, SDSale reported, pending cancellationN6453NUgly Johns Aircraft LLC · Afton, OKN6455CPruett Steven H · Midland, TXN6456CWab Enterprises Inc · Fountain Hills, AZN6456UN909dw LLC · Helena, MTN6457BJcb Holdings LLC · Helena, MTN6459CBallair LLC · Dalhart, TXN645ADAnacostia Medical Associates Pllc · Millersville, MDN645ASKing Aero LLC · Sharon, MAN645BDFly 645bd LLC · Louisville, KYN645CGainous David C · Port Saint Joe, FLN645CDSkylane LLC · East Hampton, NY
Back to AD 2012-10-13