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.
N1994MAgile Aviation LLC · Rotonda West, FLN1994UBoney C Steven · Bethel, AKN1994XCovenant Flyers LLC · Sharpsburg, GAN1994ZGoldberg Marc Fred · Chandler, AZN19954Aslam Obaid M · Houston, TXN19955Sayre Reid L · Raleigh, NCN19956Gulfstream Boats Inc · Cortez, FLN19958Snell Arthur R · York, PAN1995GHarris Justin R · Hico, TXFirst renewal noticeN1995QHooper Jonathan P · Andrews, NCN1995URegistered aircraftN19962Koosman Shawn · Dresser, WIN19967Bdc Aero LLC · Miami, TXN1996MHarrison Dan H · Englewood, FLN1996USmith Aviation LLC · Sitka, AKN1996ZEvans Christopher L · Summerville, SCN19971Woitas Jody R · Rogers, ARN19972Virzi Michael A · Independence, OHN19976West Mi Shooting Alliance For Excellence In Safety · Marne, MIN19977Moody Matthew Joseph · Homewood, ALN19978Rydeout Aviation LLC · Lake Placid, FLN1997EOlsen Grain & Livestock Inc · Whitewater, MTN19982Hayton James B · Sedro Woolley, WAN19983Twin Falls Fliers Inc · Twin Falls, IDN19987Sprinz Steven B · Rimrock, AZN19988Havener Ronald R · Overland Park, KSN1998MExecutive Aviation LLC · Peoria, AZN1998VLedbetter Zachary S · Wasilla, AKN1998XBlue Sky Powers N1998x LLC · Dover, DEN1998ZMilhous Richard J · Aguila, AZN19992United Manufacturing Inc · Holland, MIN19996Wings Over Texas Holdings LLC · Denton, TXN19997Neel Aviation LLC · Lakeland, FLN1999MSoltis Andrew · Salem, OHFirst renewal noticeN1999QGentry Harry J · Canton, OHN1999UKarr Brandon · Everett, WAN1999XThompson Justin · Duncan Falls, OHN199ARBarr Air Patrol LLC · Mesquite, TXN199GFogelson Robert A · Benton City, WAN199LPAircraft Guaranty Corp Trustee · Oklahoma City, OKN199MCFly N199mc LLC · Nevada City, CAN199NLees Larry J · Pryor, OKN199PDCity Of Sacramento · Sacramento, CAN199RFBravo Charlie Global LLC · Kalispell, MTN199RNWestern Flying Club Inc · Burlington, NCN199TKDangel LLC · Hailey, IDN199YCKruse Adam L · Weiser, IDN19AJBayshore Aircraft LLC · Miami, FLN19DEchelon Right LLC · Nicholasville, KYN19DBDcs Air LLC · Pulaski, WI
Back to AD 97-01-13