AD 2012-01-11
Registered aircraft · 3,100
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-01-11')
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-01-11')
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-01-11') 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-01-11') 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.
N161JWRjss Aviation LLC · Portland, ORN1620BNatrix Aviation LLC · Sagaponack, NYN162BFlight 19 LLC · Atlanta, GAN162CFGroeneveld Lisa · South Burlington, VTN162JBGjm Aviation LLC · Petal, MSN163SDAre You Cirrus LLC · Glasgow, MTN164CPHighwings LLC · West Fargo, NDN164CTBuckley Aviation LLC · Swainsboro, GAN164KFValiair Ltd Co Trustee · Casper, WYN164KXN164kx LLC · Charlotte, NCN164TBBuzza Tim · Cudjoe Key, FLN165JBN165jb LLC · Dayton, OHN165LMSig Cirrus LLC · Powell, OHN165LRAircraft Trustee Services Inc Trustee · Dover, DEN165MWN723 LLC · Denver, CON166BGColumbia Asset Trust Corp Trustee · Wichita, KSN166CAMca Aviation LLC · Cartersville, GAN166SMRegistered aircraftRegistration pending, pending cancellationN167AJRogers Wallace III · San Antonio, TXN167JCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN167KMRegistered aircraftN168AGN168 LLC · Irvine, CAN168PSBkt LLC · Leawood, KSN169MRSky West Aviation Inc Trustee · Albuquerque, NMN16EUCirrus Design Corp · Duluth, MNN16MTAmarone LLC · Charleston, SCN16MXCirrus Design Corp · Duluth, MNN16MYAgi Inc · La Canada Flt, CAN16YZBerit Merkab LLC · Monroe, NCN1713HGay James · Rochester, MNN171FRSilver Fox Aviation LLC · Milstone, NJN171HZLt Aviation LLC · Downers Grove, ILN171TXMigliorini Alexander P · Eureka, CAN173CKKali Equipment 2 LLC · Burlingame, CAN174GLAviation Services LLC · Chicago, ILN174MHMartins Aviation LLC · London, KYN174MPCirrus Design Corp · Duluth, MNN174SKSaltt Air LLC · Oakland, MDN1767PSteciuk Paul B · Saratoga Springs, NYN176FDCirrus Design Corp · Duluth, MNN176KMAssociated Packaging Inc · Gallatin, TNN176QBse & Associates Inc · Sacramento, CAN176WEFlying D Labs LLC · Bend, ORN1776XAgl Aviation LLC · Temecula, CAN178ATFraser Jamie A · Nokomis, FLN178CATeddymax LLC · Sarasota, FLN1798ZCirrus Design Corp · Duluth, MNN179JDFarnborough Aircraft Inc Trustee · Wilmington, DEN17DARegistration Pending · Pecos, NMRegistration pendingN17DTFinney Aviation LLC · Bloomington, IN
Back to AD 2012-01-11