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.
N234JGBartlett William F · Jackson, WYN234JSOcean Blue Aviation LLC · Farmingdale, NYN234MSVertical Horizon Aviation LLC · Sandown, NHN234PCCaldwell Larry R · Florence, KYN234PEDunn Linwood B · Franklin, TNN234PKHintz Courtney N · San Antonio, TXN234PSTkn Holdings LLC · Pima, AZN234PWRight Rudder LLC · Sapulpa, OKN234QASteinke Mark · Camas, WAN234RCRonnie G Crider Pa · Clearwater, FLN234RKShelton Raymond O · Jeanerette, LAN234RMWilliams Walt A · Mena, ARN234SBDaly Arthur P · El Paso, TXN234THHalbur Lucas R · Omaha, NEN234TLLanflisi Robert A · Fairfield, CAN234TMMisakian David L · Novato, CAN234TSGolod David A · Ossining, NYN234VRSnyder Jack W · Cheney, KSN234WAWiseman Aviation Inc · Flagstaff, AZN234WLGalaxy Sea Lift LLC · New York, NYN234ZGAtlas Aviation LLC · Buckhannon, WVN23500Windsense LLC · Charleston, SCN23502Thompson Timothy L · St Croix Falls, WIN23504N23504 LLC · Fort Pierce, FLN23508Aviato Research LLC · Phoenix, AZN2350CKeating John C · Prosper, TXN2350EMelbourne Flight Training LLC · Melbourne, FLN2351CClemens Aviation LLC · Wichita, KSN2351FStewart Anthony D · Blytheville, ARN2351GBradley John · Edgewood, NMN2351RBrockman Robert L · Christoval, TXN2351YToes In The Sand LLC · Bentonville, ARN2352CMcmahan Johana · Gakona, AKN2352RElkhorn Aviation LLC · Mandan, NDN2353COverly Terrence Lee · Tok, AKN2353GCascade Aero LLC · Scotts Mills, ORN2353USelman Charles D · Pflugerville, TXN2354CMoma Donald R · Wasilla, AKN2354EGaruda Flight Training LLC · Miami, FLN2354GJbtg LLC · Poplar Bluff, MON2354RCarter Bradford J · Rockland, MEN2354SSkymaster Stc LLC · Mena, ARN2354XNorth Coast Aeronautical LLC · Cleveland, OHN2355CFerguson Edward P · Fargo, NDN2355EAce Of Spades Aviation LLC · Las Vegas, NVFirst renewal noticeN2355RLima Mike Inc · Ham Lake, MNN2355XVan Every Jason E · Cleburne, TXN2355YSchwarz Enterprises LLC · Huntington Beach, CAN2356Dunn Cole E · Florala, ALN2356GKajans Donald F · Reno, NV
Back to AD 97-01-13