AD 79-10-14 R1
Registered aircraft · 56,582
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-10-14-R1')
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-10-14-R1')
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-10-14-R1') 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-10-14-R1') 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.
N9322GHutchinson Darrold Trustee · Hingham, MTN9322XCivil Air Patrol Inc · Maxwell Afb, ALN9323BCarter Lance F · Bangor, CAN9323ESchock Richard F II · Peoria, ILN9323XBertelsen Sven Erik · Gulfport, FLN9324CWillig Zachary · Angola, INN93260Webb Michael · Magnolia, TXN93262Land Office LLC · Burlington, CON93267Cachorro Cattle Co · Granbury, TXN9326DAll Seasons Aviation LLC · Laredo, TXN9326EWest Bend Air Inc · West Bend, WIN93272Grossman Marc · Lake Oswego, ORN93274Wltf LLC · Caldwell, IDN93276Fitzgerald Robert Paul · Eagle River, AKN9327ERhoades Christine · Laguna Beach, CAN9327XHull Ray · Waynoka, OKN93285Corrie Brent · Vero Beach, FLN9328BDethlefs Darrell C · Mechanicsburg, PAN9328UFlymoore Ventures LLC · Saint George, UTN93295Gates Steven · Midlothian, TXN93298Callen Jerry R Jr · Jerome, IDN9329BSngdo Emergency Medicine Inc · Spring Hill, FLN9329CWoodcock Tanner E · Red Lodge, MTN932AZN932az LLC · Miami, FLN932DBVanvalkenburg Eric · Hudson, WIN932FGTextron Aviation Inc · Wichita, KSN932FWJones Joseph A · Covington, WAN932RKRegistration Pending · Palmer, AKRegistration pendingN9330BCarpenter Michael R · Wasilla, AKN9330CAircraft Structural Repair Inc · Hamilton, MTN9330GHarris Ryan C · Gurley, ALN9330USt Pierre George III · Palm Bay, FLN9331CLodato Zack · Wenatchee, WAN93323Smith Ellis E · Anchorage, AKN9332HLeppke Lyle K · Marion, KSN9332TMiller Aircraft Services Inc · Crookston, MNN9332XM & D Blomquist LLC · Central Valley, UTN93330Burden John C · Decatur, TXN9333CDunkley Bret Y · Kotzebue, AKN9333GEdinger Larry D · Stroudsburg, PAN9333TLiley Paul T · Anchorage, AKN9333URoe Russell M · Martinez, CAN9333X1927 Enterprises LLC · Overland Park, KSN93343Mcivor Bruce D · Menomonie, WIN93344Cardinal Headings Ltd · Wilmington, DEN9334HFree State Flying Club · College Park, MDN9334TNelson Scott M · Eagle River, AKN93350Rowe M D Trustee · Bozeman, MTN93354Utah County Sheriff · Spanish Fork, UTN9335CKoeritz Steven R · Anchorage, AK
Back to AD 79-10-14 R1