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.
N9907AHuff Steven D · Lake Havasu City, AZN9907BMalone Parachute Club Inc · Williston, VTN9907HMather Aviation LLC · Mather, CAN9907QPlasco Designs Of Arkansas Inc · Texarkana, ARN9908AKelly Larry E · Currie, NCN9908EAndrews Allen P · Longview, TXN9908GHarrison Jon Wittmeyer · Port Saint Lucie, FLN9908VDls Computer Services Inc · Lake In The Hills, ILN9909NMorgan Vernon E · Dillon, CON9909QCk Aviation LLC · Charlestown, INN9909XMameli Tyler L · Williamson, GAN9909ZLake And Peninsula Airlines Inc · Port Alsworth, AKN990BFlight Academy LLC · Van Nuys, CAN990CAJundi Adam · North Royalton, OHN990CKSaucier Christopher A · Marion, MTN990CPCivil Air Patrol Inc · Maxwell Afb, ALN990USimpson Reed · Marco Island, FLN990VPValenzuela Pedro · Douglas, AZN990WPThomas Field Flying Club LLC · Holly Springs, MSN99100Sterling Flight Training LLC · Jacksonville, FLN99104Dury Aviation Services Inc · De Soto, ILN9910ABach Jeremy · Camp Verde, AZN9910ESmoke Eagles Inc · Newport Beach, CAN9910MSatran Paul C · Detroit Lakes, MNN9910NRunner Douglas A · Ashby, NEN9910QTevebaugh Dennis J · Elkhart, KSN9910XHower Loyal L · Moscow, IDN9911ADaniels Bayce D · Anthony, NMN9911BGustafson Kim · Lake Stevens, WAN9911HDouglas Forest Protective Association · Roseburg, ORN9911QAeronautical Technical Service Inc · Collierville, TNN9911VInternational Air Services Inc Trustee · Carson City, NVN9911XDesolation Aviation LLC · Fort Worth, TXN9912AEvans Alfred M Jr · Kingston, OKN9912LCivil Air Patrol Inc · Maxwell Afb, ALN9912NRegistered aircraftN9912QKd Aviation LLC · Sheridan, WYN9913EHobot LLC · Springdale, ARN9913GProtac Aviation LLC · San Diego, CAFirst renewal noticeN9913MVillapudua Ruben Ruiz · Phoenix, AZN9913VIsern Douglas J · Golden, CON99141Airgo Inc · Centralia, ILN9914ESimica Charles A · Marietta, GAN9914GKunas Matthew · Akron, OHN9914LFlex Air Holdings Inc · Manhattan, KSN9914MLabra Victor David · Mesa, AZN9914QVictor Aviators Inc · Kernersville, NCN9914VJennair LLC · Wilmington, DEN99157Hess Garrett J · Fullerton, CAN9915AAbel Elliot A · Terre Haute, IN
Back to AD 79-10-14 R1