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.
N9335EParanjpe Vasant · Pittstown, NJN9335XFlorida Gas Transmission Co · Spring, TXN93362Bouvier Ellis C · Prineville, ORN9336CLarson Lynn R · Casselton, NDN9337EMarianas Air Transfer Inc · Saipan, MPN9337GHaller Lonette J · Mobile, ALN9337HLorraine'S Blue Sky Aviation LLC · Norman, OKN9337XValentine Richard E · Holt, FLN93380Stahla Robert E Trustee · Grand Island, NEN9338BTopp Jason · Grace City, NDN9338EComanche Hills Aircraft LLC · Lampasas, TXN9338HSchab Davis Maragaret A · Spangle, WAN9338XHathaway David P · Waterbury, VTN9338ZBarr Air Patrol LLC · Mesquite, TXN9339XSedona Aviation LLC · Sedona, AZN933CPCivil Air Patrol · Maxwell Afb, ALN933CSTextron Aviation Inc · Wichita, KSN933DB933db LLC · St Louis Park, MNN933DDHarris John Alfred · Havana, FLN933LAMindy Limited LLC · Muscatine, IAN933PAerowood Aviation LLC · Monroe, NCN9340BCook Raymond L · Spring Grove, ILN9340CWolfe Donald E · T Or C, NMN9340UJohnson Cory D · Rugby, NDN9341BYager Keith E · Eugene, ORN9341HAndreas Neil A · Yakima, WAN9341XKent Steven P · Warwick, NYN9342FChurchill David J · Bear, DEN9342GBaumann James J · Trabuco Canyon, CAN9342HGutierrez Ricardo · Downey, CAN9342RCampbell Gene H · Baytown, TXN9342TChristiansen Aviation LLC · Wilmington, DEN9343BBas Part Sales LLC · Greeley, CON9343DAva Aviation LLC · Tappan, NYN9343GOlivo Investments Group LLC · Richmond, TXN9343TJansen Guy A · Lynden, WAN9343ULazor Ronald E · Middlefield, CTN9343XYoung Charles T · Los Banos, CAN9344BSumners David O Jr · Eastville, VAN9344CPage James S · Avoca, TXN9344FAtp Aircraft 2 LLC · Wilmington, DEN9344HBarnstormers Flying Club Inc · Pulaski, TNN9344LCivil Air Patrol Inc · Maxwell Afb, ALN9344UNewman Thomas E · Saint Ignatius, MTN9345BPasquariello Thomas · Alton, NHN9345CBunting Gordon E · Bend, ORN9345GFrederick Paul M · Tucson, AZN9345LHaynie Aviation LLC · Alexander City, ALN9345XBordner Christopher P · Santa Cruz, CAN9346BHarter Wayne R Jr · Alliance, OH
Back to AD 79-10-14 R1