AD 2011-06-10
Registered aircraft · 998
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:2011-06-10')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-06-10')
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:2011-06-10') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2011-06-10') 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.
N333WRRes Ipsa Aviation LLC · Atlanta, GAN334CCil Aviation LLC · Indianapolis, INN339MAAddie Holdings LLC · Jackson, TNN33CALrb Aviation LLC · Catawba, NCN33LMSkymax LLC · Stanford, KYN341MC1 Mc LLC · Johnstown, PAN344WASorensen Air LLC · Syracuse, UTN345MMMarciaran LLC · Dover, DEN345RPMcdole Consulting LLC · Southern Shores, NCN346TMDierking Jason Michael · Storm Lake, IAN346TXKurk Mcginley Enterprises Inc · The Woodlands, TXN347DWSnoopy Air LLC · Branch, LAN350ARAbode Construction Inc · Marion, IAN350AZTuckerman David B · Lake Stevens, WAN350BRMmhc Logistics LLC · Memphis, TNN350CGWesco Resources Inc · Billings, MTN350CSCrosswinds Properties Of Nh LLC · Meredith, NHN350DLatitude Aviation LLC · Spring, TXN350DCCampbell David Charles · Tavernier, FLN350E316sa LLC · Wilmington, DEN350FRegistered aircraftN350FGScherr Scott · Bryan, TXN350HLSaratoga Aviation LLC · Watertown, NYN350HNPowerlift Door Consultants Inc · Spearfish, SDN350HWAsher Holdings LLC · West Jefferson, NCN350JJMedical Consulting And Solutions Inc · Wilmington, DEN350KYKilo Pappa Service One LLC · Lewes, DEN350LVSilver Eagle Aviation LLC · Las Vegas, NVN350MTPhoenix Air Transport LLC · Baton Rouge, LAN350MXDraughon Brothers Inc · Fayetteville, NCN350PFKnight Brothers Inc · Corinth, MSN350PMCcc Holdings LLC · Bluefield, WVN350PUSouthern Aircraft Consultancy Inc Trustee · Casper, WYN350RDN350rd LLC · Bluffton, OHN350SAPiper Aircraft Inc · Vero Beach, FLN350SNMarco Aviation Services Inc · Neosho, MON350TVCloverfield Aero LLC · Los Angeles, CAN350TZMangione Thomas J · Kamas, UTN350USkyrocket Property LLC · Harlingen, TXN350VBPip 350 Mt L.C. · Darby, MTN350VTCope Daniel Patrick · New York, NYN350WN350w LLC · Jenks, OKN350WDLillyair LLC · Naples, FLN350WLJal Equipment LLC · Houston, TXN350WMBank Of Utah Trustee · Salt Lake City, UTN350WTM & M Gosch LLC · Temecula, CAN350XCK & W Holdings Inc · Port Orange, FLN350XLN350xl Inc Trustee · Wilmington, DEN350XPChristenson Advisory Team LLC · Great Falls, VAN350XSSchoenig Joe · Alto, NM
Back to AD 2011-06-10