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.
N2356RBledsoe Charles J · Jackson, GAN2356UPanko Jeffrey A · Lusby, MDN2357FBachand Kevin L · Leesburg, VAN2357XScavera Kevin · Madras, ORN2358EAircraft Guaranty Corp Trustee · Oklahoma City, OKN2358FEast County Communications Inc · Hurricane, UTN2358SBornhoft Jerome T · Riverton, WYN2358URegistration Pending · Cave Creek, AZRegistration pendingN2359FSheldon David E Trustee · Idaho Falls, IDN2359RTide City Air LLC · Germantown, TNN2359XHarker Charles R · Suwanee, GAN2359YWadsworth Edwin Allen · Sarasota, FLN235AZSchlenker David D · Marine St Crx, MNN235HLBeach Norman G Jr · Newman, CAN235NYCivil Air Patrol Inc · Maxwell Afb, ALN2360CCkt Aviation LLC · Anchorage, AKN2360GVath Edward V · Acton, CAN2361GMcmanigle Jeffrey M · Osakis, MNN2362RBarone Christian · Stratham, NHN2362SMclaren Institute Of Transporation Technologies · Goode, VAN2362XFort Scott Family Medicine Pa · Fort Scott, KSN2363FColumbus State Community College · Columbus, OHN2363GSawaya Mark C · Spring Valley, CAN2363RVertikle Enterprises LLC · Cheyenne, WYN2363XShort Joe · Clintwood, VAN2363YPlane Pro Aviation LLC · Shelby, NCN2364CMeinershagen Charles I · Redding, CAN2364FCarlson David G Trustee · Cape Fair, MON2364GTveitnes Svein T · Whitewright, TXN2364RRegistered aircraftN2364XElkhorn Aviation LLC · Norfolk, NEN2365CStrolin LLC · Maple Valley, WAN2366CKase Gayle L · Wasilla, AKN2366EWerner Service & Trucking Inc · Saint Edward, NEN2366SDaughtrey Kevin E · Arcadia, FLN2367GSahagun Salvador G · Bothell, WAN2368UPlehn Thomas R · Las Vegas, NVN2368XD C T LLC · Wallace, IDN2369CBlackert Charles M · Delaware Water Gap, PAN2369GPeter Travis E · Casper, WYN2369UMahoney Brandon M · Laurelville, OHN2369YMischel John Patrick · Salyersville, KYN236AMyotis Ltd · Leesburg, VAN236AFAero Fisheries Inc · Fort Pierce, FLN236AGTroposphere Ventures LLC · Fond Du Lac, WIN236ATN236at LLC · Miami, FLN236DAFalany Curtis E · Tallahassee, FLN236KAKamaka Air LLC · Honolulu, HIN236NYCivil Air Patrol Inc · Maxwell Afb, ALN236PTmg Investment Properties LLC · Surprise, AZ
Back to AD 97-01-13