AD 75-23-07
Registered aircraft · 827
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:75-23-07')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-23-07')
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:75-23-07') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-23-07') 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.
N1852EMarshall Dennis Ray Jr · Pottsboro, TXN1856EGv Air Inc · Medford, ORN1865SPima County Board Of Supervisors · Tucson, AZN187WWOsprey Aviation LLC · Riva, MDN18BKShandog Air LLC · Ashland, KYN18DLBelov Mikhail · Greenwood Village, CON18SGBennett Jeannette DBA · Joiner, ARFirst renewal noticeN18VUVincennes University · Vincennes, INN1908GAir Z Flying Service Inc · Richmond Heights, OHN1915WPasha Mohammad A · Muscatine, IAN1918JCoastal Satellite Inc · Woodland Hills, CAN1919JValiair Lc Trustee · Casper, WYN191CTBessemer Plywood Corp · Bessemer, MIN193DC310 Charter LLC · Zanesville, OHN196TCClements Dylan A · Burlington, WIN197DB310 Flyers LLC · Lafayette, LAN19DBDcs Air LLC · Pulaski, WIN19DJLewis Landon Jon · Hope, NDN19LFN19lf Corp · Oak Lawn, ILN1YCMay Thomas W · Texarkana, TXN200SHHoward Steve · Jefferson City, MON20162Wateractive43 LLC · Auburn, CAN203BNCarlson Curt · Lake Havasu City, AZN20NGTas Aviation Of Defiance Inc · Defiance, OHN20VKEvans Jeffrey L · Mansfield, LAN20WFLofton Christopher L · Harlingen, TXN213JDS&C Vending LLC · Scottsbluff, NEN213MRogers Ronald J · Crystal Lake, ILN21430Burns Preston · Spruce Pine, ALN214WGriffeth John · Branson, MON218USouthern Aircraft Consultancy Inc Trustee · Casper, WYN21CSHendrix Peter A · Plantation, FLN21FC310 Pals LLC · Lake City, FLN21GBSouthern Aircraft Consultancy Inc Trustee · Casper, WYN21HAEngle Scott · Plymouth, MNN21KBLow Carl S III · Aurora, TXN220BRSimmonds Gary Bert · San Antonio, TXN220HDAce Transport Service Inc · Wilmington, DEN220XPOleary Patrick G · Lake Tapps, WAN222MDElx Aviation LLC · Hartford, MIN222PEPacific Air Charters Inc · Honolulu, HIN222STEau Claire Aviation LLC · Eau Claire, WIN22AMJays Aircraft Maintenance Inc · Costa Mesa, CAN22ECDoose Christopher A · Memphis, TNN22GBHolland Kenneth F Trustee · Santa Clarita, CAN232ASGuggenair LLC · Carbondale, CON232RSWright Aviation LLC · Lawton, OKN234DWN234dw Aviation Inc · Okemos, MIN234TCAg N234tc LLC · South Salt Lake, UTN234TLLanflisi Robert A · Fairfield, CA
Back to AD 75-23-07