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.
N182DHWills James M · Farmville, VAN182DJPreston Robert H · Canton, OHN182DKTonso Antonio · Roseville, CAN182DLLow Richard H · Hernando, FLN182DMCourser Tony C · Escondido, CAN182DRChavez Joshua · Andrews, TXN182DTMonogram Aviation Services LLC · Coeur D Alene, IDN182DVHusbands David C · Bosque, NMN182DYMueller Matthew C · Stamford, TXN182ESwanson Jorge A · Douglas, AZN182EAGoedecke Glenn · Vestavia Hills, ALN182EB182 Flyers LLC · Spartanburg, SCN182EDCaruso Michael V · Brewster, NYN182EFMission Flight · El Monte, CAN182EGBurnette Ric · Sebastian, FLN182EJOutlaw Aviation LLC · Caledonia, WIN182EPLamm William D · Harrogate, TNN182EQAthen Daniel R · Rock Port, MON182ETEnergy Transfer Aviation LLC · Spring, TXN182EWTesk Aviation LLC · Steele, MON182FJustesen Robert G · Canyon Creek, MTFirst renewal noticeN182FAMyers Douglas J Trustee · Laurel, MTN182FBDownwind Abeam Inc · Pasadena, CAN182FFHackney Jessie · Ripley, WVN182FPTennessee Seaplane Company LLC · Knoxville, TNN182FSSmall Adam P · Hampden, MEN182FTSteves Christmas Trees Inc · Diamond Springs, CAN182GBHeem Jeremy Allen · Iowa Falls, IAN182GEGmr Leasing LLC · Lincoln, DEN182GGDel Giorgio Martin A · Flagstaff, AZN182GLMcdonough Eugene A · Glen Allen, VAN182GPDanna Frank · Castroville, TXN182GQGulf Coast Helicopters Inc · Pearland, TXN182GRSenestraro Daniel E Trustee · Johnson, KSN182GSSmith Gregory E · White Lake, MIN182GWLeflore Investors Inc · Greenwood, MSN182GZAircraft By Farkas LLC · Middleburg Heights, OHN182HAvquad Inc · Fort Collins, CON182HATurner Company LLC · Hearne, TXN182HCDrake Craig C · Brandon, MSN182HDCapel Steve · Waverly, TNN182HLBelles Flyers Inc · Wilmington, OHN182HMRosebud Aviation LLC · Roscoe, MTN182HPSmith Jody A · Grapevine, TXN182HRHotel Romeo L L C · Ketchum, IDN182HSBurris Frank · Gold Beach, ORN182JRegistered aircraftN182JBSkylane182jb LLC · Martinsville, INN182JCKaylen Products LLC · Shreveport, LAN182JENunatak Air LLC · Fairbanks, AK
Back to AD 97-01-13