AD 97-01-13
Registered aircraft · 54,837
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:97-01-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:97-01-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:97-01-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:97-01-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.
N193GSWeaver Family Farms LLC · Corpus Christi, TXN193JSRyan Moore LLC · Fayetteville, NCN193LBRiverway Capital LLC · Houston, TXN193RChase David C · Anchorage, AKN193RJSale Reported · Henderson, NVSale reportedN193SPIndiana State Police · Greenwood, INN193TATuck Aerial Surveys Inc · Big Stone Gap, VAN19400Bailis David P · Bethlehem, PAN19404Borden Kim L · Fair Haven, NYN19405Blenden Stephen R · Orlando, FLN19406Clark Caroline Ray · Anderson, SCN19409Owen James A · Jud, NDN1940FAmerican Asset Leasing LLC · Livermore, CAN19410Sather Evan A · Hayward, CAN19413Ahlgren Jon E · Juneau, AKN19414Bailey Brian D · Bethesda, MDFirst renewal noticeN19419Dean Aviation LLC · Merritt Island, FLN1941MEf Air Holdings LLC · Midkiff, TXN19422Bellefontaine Georges E · Shady Shores, TXN1942GBas Part Sales LLC · Greeley, CON1942MRegistration Pending · Linn, TXRegistration pendingN1942XGarrison Weldon · Texarkana, TXN19439Technical Education Services Inc · Virginia Beach, VAN1943MBenbrook Robert A · Blairstown, NJN1943QLeonard Joseph · Bohemia, NYN1943ZBeauford Bryan Tyler · Anderson, MON19445Scott Beau · Ashville, OHN1944EHans Construction LLC · Lititz, PAN1944GBas Part Sales LLC · Greeley, CON1944QHenry Peter S · Olympic Valley, CAN1944ZHauser Linda L · Ulysses, KSN19451Allison Jeremy L · Chandler, AZN19453Top Flight LLC · Wilmington, DEN1945FLake Elmo Aero LLC · Lake Elmo, MNN1945MOchs Roland P · Brighton, CON1945QSmith Thomas E Jr · Chino Hills, CAN1945XStepps Dana · Humboldt, TNN19463Aviation Trust Co LLC · Oklahoma City, OKN19469Registration Pending · Summerland Key, FLRegistration pendingN1946GPartwin421 LLC · Greenwich, CTN1946QMoore Garrie W · Georgetown, TXN1946VLeading Edge Aviation Inc · Doylestown, PAN19476Havron Dana Houston · Huntsville, ALN19477Rare Birds LLC · Yukon, OKN19479Kunkle Bryan S · Mount Morris, NYN1947FMelbourne Flight Training LLC · Melbourne, FLN1947QBailey Jr James E · Rittman, OHN19480Blair Mark · Kingman, AZN19481Majors Flying Club · Greenville, TXN19486Beavers David Allen · Strasburg, CO
Back to AD 97-01-13