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.
N2911UNight Sky LLC · Canton, SDN2911XRobbins Donald V · Anchorage, AKN2911YBennett John M · Cameron, NCN29127Shivers William L Jr · Friday Harbor, WAN2912CMarshalee Arizona LLC · Tempe, AZN2912SWard Ascher · Oxnard, CAN29130Ernst Gregory R · Eagle Creek, ORN2913CUnable Direct LLC · Kalispell, MTN2913EG & M Aircraft Inc · Wheat Ridge, CON2913JMulti Engine Training Co Inc · Tuttle, OKN2913SMartin Richard E · Palmyra, WIN29142Hall Darryl Wayne II · Wasilla, AKN2914CSterkel Jared · Anchorage, AKN2914FHarris Zadok · Upland, CAN2914JMaverick Aviation Holdings LLC · Sheridan, WYN2914KWildness Aviation Limited · Morrison, CON2914USethi Inderdeep S · Tracy, CAN29151Inland Aerial Surveys Inc · Riverside, CAN29159Southridge Developments Inc · San Miguel, CAFirst renewal noticeN2915CField Jeff H · Simi Valley, CAFirst renewal noticeN2915FStoffregen Thomas S · Milton, WVN2915SKoch Kenneth Scott · Coolidge, AZN29160Felber Dave A · Florissant, MON29164Iturriria John · Kuna, IDN29168Galer Michael J Jr · Lockwood, MON2916AMetro Service Air Inc · Fairbanks, AKN2916FAndros Marketing LLC · Fort Lauderdale, FLN2916UJohnson Mark D · Camano Island, WAN29173Aerial Transport LLC · Wilmington, DEN2917CParks Joseph S · Wilmington, NCN2917FBennett David D · Clinton, WAN2917JRegistration Pending · Noblesville, INRegistration pendingN2917SItz LLC · Lusby, MDN2917UCelebrate Freedom Foundation · West Columbia, SCN29181Wings Of Faith · Stevensville, MTN29186Thoroughbred LLC · Kalispell, MTN29188Rugger Investment Group LLC · Tustin, CAN2918EDelpenn Flyers Inc · Dover, DEN2918JNiemann Benjamin W · Welton, IAN2918KHolmes Ronald W · Kent, ORN2918SAbove All Aviation Inc · Goleta, CAN2919CRudolph Darren M · Wasilla, AKN2919FPerez Adolfo · Conroe, TXN2919KWoodaire Ltd · Coeur D Alene, IDN2919SJust Plane Corp · Kokomo, INN291ANKb Flies LLC · Amarillo, TXN291DCT G Dunn Plumbing Inc · Hulls Cove, MEN291KFTotal Flight Aircraft Leasing LLC · Apex, NCN291RBAbbott Air Inc · Hydro, OKN291RPGtr Aero LLC · Moultonborough, NH
Back to AD 97-01-13