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.
N139LCAmedeo Flight Ops Limited · Dublin 2N13ETRp Aviation LLC · East Troy, WIN13LJLs Leasing LLC · Franklin, TNN13MEMoonshine High LLC · Midland, TXN13QAConscient LLC · Menlo Park, CAN13URQualitair LLC Trustee · MichelstadtN1416CSpanos Dean T · Port Matilda, PAN141JWGray William C · Starkville, MSN141KJVelox Aegis Inc Trustee · Wilmington, DEN141KTAscensis LLC · Wilmington, DEN142DBN 10 Aviation LLC · Gallatin, TNN142PFirelands Management LLC · Sandusky, OHN142RDS-Turns LLC · Indn Hbr Bch, FLN142WAWhisair LLC · Little Rock, ARN1439010319 LLC · Hudson, NHN143FL143fl LLC · Roseville, MIN143MDEgnazia Plane LLC · Miami, FLN143PMStorm Aviation LLC · Sacramento, CAN143RSKidwell Aviation LLC · Apopka, FLN143SGPalm Tree Aloha Aviation LLC · Cameron Park, CAN143WWNielsen Mark Andrew Trustee · Pagosa Springs, CON148BDMaroon Mountain Aviation LLC · Edwards, CON148CPKnepper Andrew M · Woodville, OHN148LCJ W Venture Aviation LLC · Concord, NCN148MDPodaddy Enterprises LLC · Acworth, GAN1495TRossi Aviation LLC · Mount Airy, MDN14DTCirrus Design Corp · Duluth, MNN14PGI3 Cirrus Holding LLC · Houston, TXN1508KWny Aero LLC · Orchard Park, NYN150GVy Holdings LLC · Midland, GAN151ALCirrus Sr22t 11110 Inc Trustee · Wilmington, DEN151JCFlying Scotsman Inc · Boston, MAN151TCCtc Aviation LLC · Toccoa, GAN152JTStork LLC · Winston Salem, NCN15317Hold East Right Turns LLC · Austin, TXN154CRPacific Avion LLC · Temecula, CAN154WPWhiskey Papa Air LLC · Flower Mound, TXN155KMMcintyre Kristen Alison · San Jose, CAN155MVBernman LLC · Scarborough, MEN156AKCress LLC · Dover, DEN157DFair Haven Aviation LLC · San Francisco, CAN157PGN777sb LLC · Helena, MTN157WFHelping Hands Partners II LLC · Wilmington, DEN159JPCirrus Design Corp · Duluth, MNN15EUCirrus Design Corp · Duluth, MNN15TGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTN15VSCirrus Design Corp · Duluth, MNN15ZRN822js LLC · Norcross, GAN1618AOne Eight Alpha LLC · Rch Palos Vrd, CAN161CDGreen Slip LLC · Valparaiso, IN
Back to AD 2012-01-11