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.
N733EEN733ee LLC · Bethany, OKN733EHSherwood Aviation Consultants Inc · Redondo Beach, CAN733FMAdams Aviation Services Inc Trustee · Wilmington, DEN7346PIntegrated Avionics Services Inc · Hampstead, MDN7347NAv8 LLC · Boise, IDN734CDJds Aviation LLC · San Mateo, CAN734HW206 LLC · Portland, ORN734TMCorporate Air Service Inc · North Salt Lake, UTN734VSVitatoe Industries Inc · Chillicothe, OHN734WGStone Aviation LLC · Traverse City, MIN734WHObermeyer Keith · Excelsior, MNN734WXRegistration Pending · Kodiak, AKRegistration pending, pending cancellationN7351UBlue Waves Holding One LLC · Miami, FLN7357CPerson Donna Mae · Columbus, NEN7359CAhlem Charles D · Hilmar, CAN735BTPtmm LLC · Columbus, OHN735DNet Trek Inc · Lanexa, VAN735XVGps Land Company LLC · Brandon, MSN7361CFocused Holdings LLC · Wellsville, UTN736CPSpivak Maxim Trustee · San Jose, CAN736SRGlobal Horizon Investments LLC · Flower Mound, TXN736WFWarner Chad · Gualala, CAN7374BAltyn Aviation LLC · Wilmington, DEN737APEaglehawk Ventures LLC · Montecito, CAN737ELCsi Flight Services LLC · Mcminnville, ORN737PM & E Horizons LLC · Slatington, PAN7384CFesco Holdings Inc · Alice, TXN7386CAgro Engineering Inc · Alamosa, CON7391PShph LLC · Edwards, ILN739MCaurus Power Inc · Santa Rosa, CAN73AEArco Enterprises Inc · Greensburg, PAN73ARStay In Your Plane LLC · Austin, TXN73BPRealty Trust LLC · Southbridge, MAN73CAShelor Investments LLC · Christiansburg, VAN73CCBoomer4 Aviation LLC · Cincinnati, OHN73CDDm Aviation LLC · Tomball, TXN73EPColburn & Associates LLC · Woodruff, SCN73HW73 Hotel Whiskey Llp · West Fargo, NDN73JQZam Air LLC · Wilmington, DEN73KDRegistered aircraftN73LLT3 Aviation LLC · Oak Point, TXN73SMBrown Michael · Gardnerville, NVN73TBMagic Leasing LLC · Peotone, ILN73TXSee Robert W · Catawba, NCN73WESchroeder Andrew R · Hoover, ALN73WFSky Park Drive LLC · Custer, SDN73WKCapital Holdings 251 LLC · Newark, DEN73WTBa Cane Aviation LLC · Weston, FLN740CAHyannis Air Service Inc · Hyannis, MAN740CD429 Aviation LLC · Dallas, TX
Back to AD 2012-10-13