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.
N758NFBoeing Employees Flying Association · Renton, WAN758NJNoble Investments LLC · Naples, FLN758NLDc Aero LLC · Ramona, CAN758NVKirk Blackstone LLC · Las Vegas, NVN758NYHall Associates LLC · Homer, AKN758PDWilliams Gary L · Hastings, NEN758PEHeise Jeffrey A · Fishers, INN758PHFarguson David M · Pasadena, CAN758PKSkyking Aviation LLC · Obion, TNN758PNColorado Northwestern Community College · Rangely, CON758PTTkj Equipment LLC · El Dorado Hills, CAN758PVLuck Richard S · Superior, WIN758PXWiley'S Little Red Wagon LLC · Osseo, MNN758PZSt Matthew Aero LLC · Kalispell, MTN758QCMccray B F Jr · Manchester, OKN758QEThomason Land Co · Garden City, TXN758QNCessna 172xp LLC · Wilmington, DEN758QPBarbee Donald L · Columbus, OHN758QVMidwest Aviation Inc · Mayfield, KYN758QX4-Gs Holding Co LLC · Cashmere, WAN758QYRegistration Pending · Arlington, TXRegistration pendingN758QZDovy Aviation LLC · Houston, TXN758RCMattern Todd A · Yuma, AZN758RJWilliams Steven M · Cazenovia, NYN758RLRegistered aircraftN758RNDavis Evan · Haddonfield, NJN758RSStewart Jon L · Walker, MNN758RVLejeune Thad · Eunice, LAN758RXBuss Rhonda K · Hustisford, WIN758SFBauer Walter G · Neenah, WIN758SYMasser Management Inc · Leck Kill, PAN758TAStonehouse William L · Clovis, CAN758TJSilverstein Bradley · Derby, KSN758TKBookout Samantha · Louisville, MSN758TNStevenson Aviation LLC · Harrisville, UTN758TSNiemiec Luke · Assonet, MAN758TTLawson Paul L · Vancouver, WAN758TVReeder Flying Service Inc · Twin Falls, IDN758TXMehn Michael J · Berlin, WIN758TY5 Star Farms · Johnson, KSN758UCL&S Adventure LLC · Rocklin, CAN758UHKobesky Jeffrey · Dunkirk, MDN758VPHorn Jon S · Phoenix, AZN758VSWieden Air LLC · Owasso, OKN758VUParlet Brian C · Banning, CAN758VWSimon Ilene F · San Mateo, CAN758WBFinity Engineering LLC · College Place, WAN758XBLet The Fur Fly · Payson, AZN758XSG & A LLC · Eagle River, AKN758XWNorton Donald A · Kodiak, AKFirst renewal notice
Back to AD 79-10-14 R1