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.
N3282TCavu Aircraft Sales & Management Inc · Olyphant, PAN3283DAllen Roger B · Gardnerville, NVN3283LHill Suzanne L · Edmond, OKN3284DKornfield Edward A · Anchorage, AKN3284LWill Clifford S · Grayson, GAN3284MSonrise Aviation LLC · Portland, INN3284YMonnin Cass C · East Wenatchee, WAN3285LDouglass Grant · Rockport, TXN3285SCastro Manny H · Tucson, AZN3285VAviate Navigate Communicate LLC · Dewey, AZN3286JJohnson David W · Biwabik, MNN3286LEagle Eye Aviation LLC · Meridian, IDN3287EOff Course Aero Ventures LLC · Mechanicsville, VAN3288DSmith James O · Montgomery, TXN3288JSouthern Arkansas University Tech · Camden, ARN3288SEpple William E · Roggen, CON3288UVetch Rod F · Ranchester, WYN32897Mach Point Nine LLC · Phoenix, AZN3289SDouble Lazy H LLC · Delta, CON3289URutenbeck Terry L · Wiggins, CON3289YHasselbring Ted S · Nashville, TNN328DDLandsburg Custom Services LLC · Sandusky, MIN328JKJk Aviation Venture LLC · Windermere, FLN328LDuffield Brian · Eastvale, CAN32909Zamarripa Hector · Brownsville, TXN3290FCline Mark A · Winston Salem, NCN3290JFitzgerald Jacob J · Pullman, WAN3291EKukuchka Ronald G · Tunkhannock, PAN3291LSun Baron · Arcadia, CAN3291SRegistration Pending · Highland, ILRegistration pendingN3291ZMiller Andy D · Marana, AZN3292MHyannis Air Service Inc · Hyannis, MAN3292TCelestial Kinetics Flight Academy LLC · Waupaca, WIN3292UAnnecchini Frank C Jr · Overland Park, KSN3293DGuilliams Carl · Gilbert, AZN3293YKiedinger John D · Burleson, TXN3294TWolniansky Peter W · Ocean Grove, NJN3294UWidener Christine A · Tucson, AZN3295JClonts Kim E · Knox City, TXN3295YReid Brian M · Boise, IDN3296SBeekman Steven J · Stephenson, MIN3296UBierer David E · Victor, MTN3296YBeckord Aaron P · Tacoma, WAN3297LRaymond Patrick H · Jerseyville, ILN3297TBurgdorf Dale A · Plano, TXN3297YMust Dash Rides Flying Club LLC · Raleigh, NCN3298LThompson Edward E · Buxton, MEN3298SHolloway Cody L · Belle Plaine, KSN3298T515 Aviation LLC · Dexter, IAN3299EBeglin Bruce W · Oxford, MD
Back to AD 97-01-13