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.
N2873YMorris Ben M · Albany, GAN2874KWashburn Kent F · Grants Pass, ORN2874LSchirack John · Decatur, INN2875LDavenport Ross K · Raleigh, NCN2875QLani Lea Sky Tours LLC · Honolulu, HIN2875SHolland Van D · Sandy Valley, NVN2875UWalter Karl F · Fayetteville, GAN2876FJohnston Natalie R · Edgewood, TXN2876SRay Charlie B · Prosser, WAN2876UPianalto David · Wichita, KSN2876YForbes Richard L · Plano, TXN2877ADutremble Donald L · Amherst, NHN2877SWarner David F · Altoona, IAN2877UMelin James · Livingston, MTN2877XJim Doherty Trucking Inc · Sacramento, CAN2877YBrumback Recreation LLC · Bluffdale, UTN2878AAero Garage Inc · Fort Myers, FLN2878LHolbrook David A · Toccoa, GAN2878QFields Williams H · Greensboro, NCN2879FMinich Sophie R · Anchorage, AKN2879KTwo Niner Kilo LLC · Seattle, WAN2879QBlue Side Aviation LLC · Tampa, FLN2879XGregoire Louis Bernard III · Blairsville, GAN287BWDaniels Kelly M · Humble, TXN287TCAiv Con Inc · Charlevoix, MIN2880EDemulling Michael C · New Richmond, WIN2880RPhelps Thomas J · Orem, UTN2880SHigh Exposure Inc · Wilmington, DEN2880XGerstung Dennis R · Anchorage, AKN2880YRegistered aircraftN2881FAirplanes Over Niagara LLC · Lewiston, NYN2881LCore Alan L · Indianola, IAN2881QNeenah Aircraft Leasing LLC · Neenah, WIN2881SSerbus Gary E · Olivia, MNN28822Edwards Gordon O · Casper, WYN2882YVx Aviation LLC · Palisade, CON28835Waddingham William B · Rancho Cucamonga, CAN2883RCallegari Sergio P · Reno, NVN2883UPaul Aviation LLC · Sault Sainte Marie, MIN2883XRamano Raymond C · Napa, CAN2884ADowns M Todd · De Leon, TXFirst renewal noticeN2884FTurner Michael B · Covington, TNN2884KJ Robert Finley And Associates Inc · Mountain Home, ARN2884RSalem Coastal Enterprises LLC · Elizabeth City, NCFirst renewal noticeN2884UEast Tenn Pilots Club Inc · Knoxville, TNN2884YTri-Aviation Inc · Amarillo, TXN2885LBlevens George A Jr · Franklin, KYN2885QFisher Global LLC · Conway, ARN2885SWinter Thomas N · Lincoln, NEN2885UEda4 LLC · Cresson, TX
Back to AD 97-01-13