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.
N776BRWillow Tree Tennessee LLC · Lakeland, TNN776BWN776bw LLC · Alpine, WYN776CDTriple Crown Aviation LLC · Las Vegas, NVN776CMNewman Air LLC · Sherborn, MAN776DSullivan Dennis · Santa Ana, CAN776DADavisair Inc · Raleigh, NCN776DNPdn Aviation LLC · West Chester, PAN776JDSr22 LLC · Chubbuck, IDN776JEJde Higher Cause LLC · Jenison, MIN776PMHoudashell Investments LLC · Amarillo, TXN776TMAero Performance LLC · Scooba, MSN776XBere Matthew Robert · Dallas, TXN776YDRapp Larry · Elbow Lake, MNN7772LJerez John J · Bonita, CAN7772TVista Haven Leasing LLC · San Antonio, TXN7773HCirrus 7773h LLC · Wilmington, DEN7774BAdair Aviation LLC · Broken Arrow, OKN7774PBlack Scorpion LLC · Helena, MTN7774ZLaw Office Of Yossi Noudel · Encino, CAN7776HAcevedo Adriel · San Antonio, TXN7776TBlue Horizons Holdings LLC · Wilmington, DEN77770Bredder Brett A · Brighton, CON7778GDgt Management Company LLC · New Bern, NCN7778TTayara LLC · Durham, NCN7779XNorcal Flight Services LLC · Palo Alto, CAN777AJV-R Holdings LLC · Sauget, ILN777AVOverwatch Aero LLC · Santa Maria, CAN777BMJet Air Of South Florida Inc · Deerfield Beach, FLN777CL777cl Aviation LLC · Sheridan, WYN777DPittsburgh Institute Of Aeronautics · West Mifflin, PAN777DLShamrock Kelly Energy Inc · Blanco, TXN777EConner Ernest A · Dallas, TXN777EVSelldorff John · Chatham, MAN777FYQualitair LLC Trustee · ChelstadtN777GBFc Sr Capital LLC · Anaheim, CAN777GVPerry Robert A · Tucson, AZN777HSJohnson Erik L · Long Beach, CAN777JJh Industries Inc · Fort Mohave, AZN777MGreen Airplane LLC · Denver, CON777MYGraham Elmer R Jr · Graford, TXN777NHS And S Airlink · Troy, MIN777NKTaylor Jonathan K II · Granbury, TXN777NLOrthoair LLC · Union City, TNN777PCPhase Three Marketing LLC · Helena, MTN777PSSouthern Aircraft Consultancy Inc Trustee · Casper, WYN777RPParis Air Conditioning Co · Paris, TXN777RYMacair Aviation LLC · Xenia, OHN777VMiso Enteprises LLC · Wilmington, DEN777VBArizona Thunderbolts LLC · Scottsdale, AZN777VFZammit Flight Resources LLC · Sheridan, WY
Back to AD 2012-10-13