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.
N3959POmaha Aircraft LLC · Blair, NEN395CDSimpson Russell · Nantucket, MAN395CPVallencourt Jonathan Daniel · Green Cove Springs, FLN395DATriton Polaris LLC · Suwanee, GAN395LMMj&J LLC · Dodge City, KSN395SAFmco Promotions Inc · North Little Rock, ARN3968QTundra Wings Ministries · Wasilla, AKN396BSpring Creek Financial Inc · Lewistown, MTN397AGMelmed Gavin · Dallas, TXN397AWPapa Tango Aviation LLC · Kalispell, MTN397DDDelta Delta LLC · Washington, DCN3983GBank Of Utah Trustee · Salt Lake City, UTN398DLWiley David J · Emmetsburg, IAN398EHayes Aero Design Group LLC · Palm Beach Gardens, FLN398JTNiner18 Ventures LLC · Kingsville, MDN398LJDakota Heavy Equipment · Fargo, NDN398MWJtde Aircraft Holdings LLC · Lebanon, OHN398SAirscrew Aviation LLC · Youngstown, OHN3992GFlat Earth LLC · Kalispell, MTN3995GCutting Edge Design & Contracting-Sc Inc · Elgin, SCN399BWCharleston Executive Aviation LLC · Johns Island, SCN399CAHoman Mark A · Wake Forest, NCN399DDFly Flying Buffalo LLC · Dawson, GAN399DZRegistration Pending · Bettendorf, IARegistration pendingN399KMCustodio Olga · San Antonio, TXN399SMShroder Partners LLC · Sarasota, FLN399TABeattie Richard N Trustee · Anacortes, WAN39AATvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN39BTMidwest Aerial Photography · Galloway, OHN39CDTexas Wings In The Air II LLC · El Paso, TXN39DDLarson Danny O · Palmer, AKN39EETamburo Michael J · Adkins, TXN39HCTherapy Air LLC · Midland, TXN39HWApple & Vine Aviation Services LLC · Reidsville, GAN39JSWestland Business Services Inc · Gallatin Gateway, MTN39KCCapital Holdings 245 LLC · Newark, DEN39LFFeingersh Larry · Houston, TXN39TKCold Water Aviation LLC · Wabasso, MNN39VFLight Source Inc · Charlotte, NCN39VPCare Flight LLC · Camden, DEN39WGAerojet Solutions LLC · Sarasota, FLN39WVLojac Air LLC · Yukon, OKN3AFAf Air LLC · Tulsa, OKN3CBAk Aviation LLC · Melbourne, FLN3CCN3cc LLC · Auburn, ALN3CFFlying Success LLC · Apex, NCN3CK3ck LLC · Bellevue, WAN3CYSchultz Daniel A · Tipp City, OHN3DQCrescent Aviation LLC · Rllng Hls Est, CAFirst renewal noticeN3ELTwo If Buy LLC · Nashua, NH
Back to AD 2012-10-13