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.
N311PGKumar Shekar · Greenwood, SCN311TCN311tc LLC · Tacoma, WAN311TDWw House Inc · Lumberton, TXN311XXWeekend Pass LLC · Golden, CON3122MMiller-Jackson Co Inc · Oklahoma City, OKN3122RMarrow Henry G · Southern Pines, NCN3122UTravel Aviation Inc · Vineyard Haven, MAN31291N31291 Aviation LLC · Omro, WIN312ADAltier Daniel T · Bloomfield Twp, MIN312AEN312ae LLC · Seffner, FLN312APAtish LLC · Hermosa Beach, CAN312CPSsi Mechanical LLC · San Antonio, FLN312DKline Robert H · Oley, PAN312DATspy Services Inc · Wilmington, DEN312DXPowder Day Aviation LLC · Camden, DEN312DYParte Tercero LLC · Irvine, CAN312FPEger Aviation LLC · Pittsburgh, PAN312GEKalsi Pritpal · Clarksburg, MDN312GMSonas Aviation Inc Trustee · Wilmington, DEN312GTKiser Consulting LLC · Atlanta, GAN312HWdc Aviation LLC · Scottsdale, AZN312JBBadmia LLC · Polk City, IAFirst renewal noticeN312MGMyles To Go Aviation LLC · Camden, DEN312MSGulf Of America Aviation LLC · Brookshire, TXN312MTP Mitchell LLC · Las Vegas, NVN312NGNovember Golf LLC · Shamong, NJN312PXRauschenberger Ventures LLC · Chicago, ILN312REBlue Jay Family Office LLC · Wilmington, DEN312RKRjk Air LLC · Syracuse, NYN312SCBarker Family Investments Management Co LLC · Tyler, TXN312SRStorm Consulting Enterprises LLC · Tyler, TXN312WG312wg LLC · Kenilworth, ILN312XXSilver State Skies LLC · Camden, DEN3131KAmazon Aero Corp · Wilmington, DEN3136XBobbett Robert Todd · West Richland, WAN313AJAspiring LLC · Royal Oak, MIN313BRCirrus Design Corp · Duluth, MNN313DG3dg Aviation LLC · Louisville, KYN313ETImrie Aviation LLC · Jonesboro, ARN313EZFlightwerks LLC · Commerce Township, MIN313GCirrus Design Corp · Duluth, MNN313GBBurnett Gregory C · Rogersville, MON313GPGeiger Aviation LLC · Mount Pleasant, SCN313JBConchy Joe Aviation LLC · Fort Lauderdale, FLN313KGJj Aviation Holdings LLC · Raleigh, NCN313LCShort Carl R · Issaquah, WAN313MEBasille Vision LLC · Lewes, DEN313MHHarder-Diesslin Development Group LLC · Salida, CON313MLAir Mer LLC · Los Altos, CAN313MPAlpha Bravo Charlie 1 Corp · Houston, TX
Back to AD 2012-10-13