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.
N416LALambourne Holdings LLC · Incline Village, NVN416PCKjt Aviation LLC · Beaumont, TXN416RARegistration Pending · Muskegon, MIRegistration pendingN416SCribbie Ronald J Trustee · Hernando, FLN416TBMyers Hollis Donald III · Lexington, NCN416TDC C Aviation Group LLC · Wilmington, DEN416USClepper Francis D Jr · Bennington, NEN416WBSoaring Eagle Air LLC · Salt Lake City, UTN4171QN4171q LLC · Newport Beach, CAN417AKViking Cake Holdings II LLC · Bend, ORN417ATAuctioneer Wings LLC · Valparaiso, INN417BSMojo Aviation LLC · Overland Park, KSN417DASkylark Holdings LLC · Costa Mesa, CAN417DTCirrus Turbo N417dt LLC · Newark, DEN417EESouth Pass Aviation LLC · New York, NYN417JRBinary Ninjutsu LLC · Myrtle Beach, SCN417KKinsley Joshua P Trustee · Carlsbad, CAN417KHWillens Mark D · Livermore, CAN417LCFowm LLC · West Memphis, ARN417MMN417mm LLC · Kirkwood, MON417PWFleur De Lis Krewe LLC · Orlando, FLN417TABrickler Alexander J · Tallahassee, FLN417WCMpi Warehouse Specialty Company Inc · Casper, WYN417WDWheels Down LLC · Oklahoma City, OKN4181TKeystone Aerial Surveys Inc · Philadelphia, PAN418BCFlying Beep LLC · Athens, GAN418GVWings & Rotor LLC · Wilmington, DEN418JCWalker Richard A · Omaha, NEN418MLLloyd Morty C · Apison, TNN418MWG2010 LLC · Greenwood Village, CON418RMWind Sock Aviation LLC · Lancaster, KYN418TRAir Sunrise LLC · Mountain View, CAN4198GWindecker Aircraft Inc · Mooresville, NCN419BBWinson Courtenay E · Tiki Island, TXN419CDRsk Aviation LLC · Midland, MIN419KDDaniel Aviation LLC · Graniteville, SCN419STMyers Steven L · Goodyear, AZN419VTThomas Builders Inc · Niota, TNN419WMGalf Aviation LLC · Thousand Oaks, CAN41ARobertson Roy E · Marion, IAN41ARAdeline Air LLC · Scottsdale, AZN41AYHunterdon Aviation Inc · Ringoes, NJN41AZAlexander Peter · Palo Alto, CAN41CASale Reported · Trapper C Reek, AKSale reportedN41CEWhats Up Doc Aviation LLC · Alexander, ARN41DKCirrus Sr22t 11533 Inc Trustee · Wilmington, DEN41DNNevels Donald L · Everton, MON41DWOne Delta Whiskey LLC · Westport, CTN41EGSal Aviation Inc · Wilmington, DEN41GDValiair Lc Trustee · Casper, WY
Back to AD 2012-10-13