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.
N72PVBowman Theodore R · Santa Ynez, CAN72PWAndrews Aviation LLC · Coralville, IAN72SCLsa Aircraft Holdings LLC · Houston, TXN72TFLeuthner Roger B · Albuquerque, NMN72VTNot Enuf LLC · Jackson, WYN7301PPan Steve · San Francisco, CAN7303NJordan James D · Paradise, TXN7305URyan Air Inc · Anchorage, AKN730AFB Fam LLC · Texico, NMN730BGBc Aviation LLC · Valdosta, GAN730BLHolden Simon · Napa, CAN730CN730c LLC · Merrimack, NHN730CDCirrus Associates LLC · Colorado Springs, CON730CNMaxim Aviation LLC · Scottsdale, AZN730LTLt Wings LLC · Paris, TXN730TRZero Tango Romeo LLC · Grand Junction, CON730WDWjd Services LLC · Saint Augustine, FLN730WWInternational Air Services Inc Trustee · Carson City, NVN7311KChunga Air LLC · Orange Park, FLN73123Lake Clark Air Inc · Port Alsworth, AKN731APEastway Properties LLC · Moxee, WAN731ATMark L Carman · Aiken, SCN731BJArmis Strategies LLC · Hartwell, GAN731CBAnesthesia Aviation LLC · Leesburg, VAN731CDOwen Brian F · Tulsa, OKN731CYSan Diego Air Service · San Diego, CAN731DSYou And Me LLC · Sedalia, MON731EAExperience Aviation Inc · Opa Locka, FLN731EMAuer William W · Saint Petersburg, FLN731FAFly Najd Inc Trustee · Wilmington, DEN731FEJones Marilyn W · Collinsville, CTN731FKQualitair LLC Trustee · MichelstadtN731FTMillican Clifford A · Burleson, TXN731GCLavalley Asset Management Inc · Potsdam, NYN731GVSolomon Mark Trustee · Wilmington, DEN731HRBrennan Timothy · San Francisco, CAN731HTAeolus Aviation LLC · Franklin, TNN731HWOne Hotel Whskey LLC · Hugoton, KSN731JAMccallister Aviation Rentals & Sales LLC · Qulin, MON731JGGate Air LLC · Ketchum, IDN731JHGcl Juliet Hotel LLC · Winter Springs, FLN731JXKai Herbert DBA · Rillito, AZFirst renewal noticeN731KLMullen James P Jr · Rogers, ARN731LNEastern Washington Ambulatory Anesthesia Svcs Pllc · Walla Walla, WAN731LTDodson International Parts Inc · Rantoul, KSN731LUDiversified Air LLC · Kalispell, MTN731MQClassic Management Corp · Marion, INN731NCSmith Bryan · Wenatchee, WAN731NRWife Approved LLC · Torrance, CAN731NUNgu Services LLC · Sheridan, WY
Back to AD 2012-10-13