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.
N182SZHigh Wing Aviation LLC · Phoenix, AZN182TBKelly Michael · E Wenatchee, WAN182TDJohnston Timothy L · Orr, MNN182TFHigh-Wing Aero LLC · Albertville, MNN182TGQuimby John S Trustee · Liberty Township, OHN182THStafford Developments Inc · Tupelo, MSN182TJDessau Aviation Inc · Georgetown, TXN182TKAda Forestry Division · Malvern, ARN182TMMcmillan Jon V · Newnan, GAN182TNPotter Timothy E · Murfreesboro, TNN182TPBurkeen Timothy Charles · Prescott, AZN182TTCompassion Flights Inc · Hampton, IAN182TVMacclanahan Paul J · Sisters, ORN182TWBaer Monte Wayne · Ronan, MTN182TXEnterprise Electric And Rental Inc · Enterprise, ORN182UKarl Mark G · Wilbraham, MAN182UKMarshall Christopher E · Boise, IDN182ULMedia Stew LLC · Carson City, NVN182USPbj Aviation · Portland, TNN182VZeigler Bradley C · Alexandria, VAN182VCVogeney Andrew D · Phoenix, AZN182VESale Reported · HawkestoneSale reportedN182VQDimension Controls Inc · Burr Ridge, ILN182VSMountain Aviator LLC · Edwards, CON182VVPlane Envy Aviation LLC · Winter Park, FLN182WDurham David · Reno, NVN182WAGardner David S · Los Alamitos, CAN182WBN182wb LLC · Rome, GAN182WDLewis W D III · San Carlos, CAN182WEBarr Air Patrol LLC · Mesquite, TXN182WFWhiskey Foxtrot LLC · Fort Kent, MEN182WHSorensen Welding Inc · Mahnomen, MNN182WJSchroder Curtis L · Campo, CON182WKKcn Aero Club · Overland Park, KSN182WLMckaye Thomas · Santa Paula, CAN182WPWhiskey Papa Partners LLC · Sylvan Lake, MIN182WRBarnes Stephen W · Mustang, OKN182WSBiloff Matthew L · Palmer, AKN182WTBlue Aviation LLC · Lake Worth, FLN182WVMayo Ray Cody Jr · Shreveport, LAN182WXTre Aviation Corp · Wilmington, DEN182WYWind River Flyers Inc · Pinedale, WYN182WZEmperor Aviation LLC · West Chester, OHN182XN182x LLC · Midlothian, TXN182XLMid Valley Flying LLC · Progreso, TXN182XPBd Flight LLC · Madison, WIN182XTSlattery Donald J · Midland, MIN182YDelgatto Robert G · Bellingham, WAN182YASageeyah Cessna LLC · Claremore, OKN182YBD & S Mafco LLC · Tilden, TX
Back to AD 97-01-13