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.
N3103JChiles Jimmy W · Rowlett, TXN3103VN3103v LLC · Wheeling, ILN3104FFlorida Armstron Boring LLC · Coeur D Alene, IDN3104QSauer Jason DBA · Glen Ullin, NDN3104TBrobst David D · Durango, CON3105DHenderson Raymond N · Kosciusko, MSN3105SMorgan A Douglas · Madera, CAN3105TColburn Lant R · Cleburne, TXN3105YOakley James H · Spring Valley, CAN3106CPetrie Michael · Chugiak, AKN3106QStiens Fred T · Moses Lake, WAN3106UPlattinum Leasing LLC · Smoot, WYN3107FPage Gordie R II · St George, UTN3107PRonald Waldron · Strongsville, OHN3107QWest Valley Aviation Inc · Five Points, CAN3107TRichardson Kroy · Littleton, CON3107URegistered aircraftN3107XPage Trenton Vaughn · Warner Robins, GAN3107YSturgill Ricky G · Yucca Valley, CAN31084Hannah Bruce A · Anchorage, AKN3108DOchsenbauer David J · Ashland, WIN3108FSuntech LLC · St George, UTN3108JBetzoldt Linda · Tecumseh, MIN3108QSipe Thomas L · Rhome, TXN3108RCocklebur Inc · Sidon, MSN3108SLac Avionics Inc · San Jose, CAN3109FHeligray LLC · Kalispell, MTN3109JShue Robert R Jr · Easley, SCN3109QWellink Jos · Katy, TXN3109RHerrera Antonio P · Oxnard, CAN3109TS-J Air LLC · Salem, MON3109UBernadt Bruce P · Steinauer, NEN310ACJulie Dorst LLC · Kalispell, MTN310AFSelwa Michael A · Oconomowoc, WIN310AHGraydon Bilal R · Melbourne, FLN310AJPj Aviation Holding LLC Trustee · Eden Prairie, MNN310ARHales Gutter Guys LLC · Cottonwood, AZN310AWBetty Eric · Old Hickory, TNN310BBF & F Aviation LLC · Memphis, TNN310BGFlairships LLC · Durham, NCN310BJJ A Flight Services LLC · Sugar Grove, ILN310BMTeam 67 LLC · Mount Pleasant, IAN310BSKwe Inc · Melbourne Beach, FLN310BVExec Air Inc Of Naples · Naples, FLN310CBN310cb LLC · Buford, GAN310CCLance Johnson Ministries Inc · Calhoun, GAN310CFSouthern Illinois University DBA · Murphysboro, ILN310CGHoffert Stephen · Alexander, NCN310CHWatermakers Air Inc · Fort Lauderdale, FLN310CJCj Marketing Inc · Saint John, IN
Back to AD 97-01-13