AD 79-23-07
Registered aircraft · 412
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:79-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:79-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:79-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:79-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.
N147SMMazar Stephen M · Flushing, MIN147WBTriple Sss Aviation Inc · Muskegon, MIN147WTAircraft Logistics Services LLC · Rockford, MIN14807Hammock Flying Service Inc · Smithville, ARN14827Wildhorse Helicopters Inc · Pendleton, ORN14861Brown Helicopter Inc · Pensacola, FLN1501LMonahan Robert J · Bulverde, TXN1503LTriple F Flying Inc · Benton, PAN15395Magnum Aviation LLC · Goff, KSN153AFarwest Aviation LLC · Billings, MTN155JNAero-Mobil Inc · Wilmington, DEN15AROrbic Inc · Camarillo, CAN170HFEfinance LLC · Wichita, KSN170SSOlathe Spray Service Inc · Olathe, CON17611Tc Bouslog LLC · Noblesville, INN1773Aircraft Sales LLC · Caledonia, MIN17SSDodson Larry A · Lone Oak, TXN18807Swing Wing Inc · Veedersburg, INN188SHScotts Helicopter Service Inc · Le Sueur, MNN18SSUSA Helicopter Inc · West Winfield, NYN200KVPeavy Magnus Delacy IV · Crawfordville, FLN210BL & L Delivery Ltd · Romulus, MIN2199Heritage Flight Museum · Burlington, WAN21MPBack Jeff · Oneonta, NYN2209JWildhorse Helicopter Co Inc · Pendleton, ORN2211NRoberts Edgar S · Washoe Valley, NVN222AJWatson Tommy R · Thibodaux, LAN22353Rye Corp LLC · Lenoir City, TNN2240WYarak Aviation LLC · Big Timber, MTN2248WWilbur-Ellis Co · Salinas, CAN2249WWilbur-Ellis Co · Salinas, CAN2251WJohnson Aerial Spraying LLC · Brayton, IAN2266ADt Pralle Enterprise Inc · Hampton, IAN2277WSterling Lane Helicopters LLC · Farmingdale, NYN2292BMy Way LLC · Missoula, MTN22APGospel Ministries International Inc · Collegedale, TNN22SHBryan Robert C · Waller, TXN238WFStaas Justin · Sacramento, CAN24067Pearce Michael J · Phoenix, AZN2469BKothman Kenn Kode · Sheffield, TXN2473BKerr Douglas E · Oakland, CAN247WWildhorse Helicopter Co Inc · Pendleton, ORN2490BExperimental Acft Assoc Inc · Oshkosh, WIN24MPWildhorse Helicopters Inc · Pendleton, ORN2507X4 Star Aviation Inc · Jefferson City, MON250894 Star Aviation Inc · Jefferson City, MON2508K4 Star Aviation Inc · Jefferson City, MON2509F4 Star Aviation Inc · Jefferson City, MON256SWMountain 47 LLC · Boulder, CON257PCPinellas County · Clearwater, FL
Back to AD 79-23-07