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.
N3061UWade William J · Waterman, ILN30626Hoese Ray D · San Antonio, TXN3062FJohnson Sean D Trustee · Fresno, CAN3062SRiver City Aviation LLC · Carmichael, CAN3062UMitchell Steven C · Knoxville, IAN3062XReeser Peggy E · Paige, TXN30630Erickson Keith E · Anchorage, AKN30632Evv Pilots Club Inc · Evansville, INFirst renewal noticeN30634Beck Alan · Las Vegas, NVN30636Schub William C · Oakdale, NYN30637Diamond Paul · Londonderry, NHN30639Madden Michael A Trustee · De Pere, WIN3063FT J Croach Llp · Post Falls, IDN3063JGo Around LLC · Boyceville, WIN3063SLong Aaron T · Seguin, TXN3063ULittle Bird Airways LLC · Hamburg, NYN3063XN3063x LLC · New Braunfels, TXN30643Hurst Gordon · Waterford, PAN3064SAtaee Behnam · Beatrice, NEN3064UMcintosh Randall W · Rome City, INN3064XAldridge James M · Fairbanks, AKN3064YStemper Pete L · Madison, SDN30654Eagle Sky Patrol Inc · Deadwood, SDN30656Vance Matthew Austin · Decatur, GAN3065E3065e LLC · Westfield, PAN3065FHinds Frank E · San Angelo, TXN3065QSuchy Michael R · Murrieta, CAN30661Feiler Joe · Casper, WYN30663Kroeker Bryan S · Grant, NEN30668Elevation Aviation LLC · Mccomb, MSN3066JWeyer Terry J · Edgewater, FLN3066QMeyer Vernon C · Westlake, LAN30670Brown Thomas E · Trenton, GAN30671Foster Milton F · Dawson, GAN30673Cardinal Flyers Inc · Sault Sainte Marie, MIN30677Worley Timothy Joseph · San Angelo, TXN3067EGlass Bruce D · Crystal Lake, ILN3067VStauffer Todd · Jackson, MSN3067YRegistration Pending · Bluffdale, UTRegistration pendingN30680Smith Ronald D · Anderson, INN30685Blanchette George · Longwood, FLN30686Tullos Morgan P · Austin, TXN3068FLehrman Walter M · Reedley, CAN3068JWave Soaring Adventures Inc · Lake Tapps, WAN3068SZephyrhills Flying Club Inc · Tampa, FLN3068UArlins Aircraft Service Inc · Belgrade, MTN30691Hayden Boyce · Grand Rapids, MIN30695Beck Paul D · Russell, IAN3069FBlaine Barry A · Campbell, CAN3069JSkymax Holdings LLC · Spokane, WA
Back to AD 97-01-13