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.
N5661BPiekarski John G · Kuna, IDN5661TSingletary Kenneth W · Newman Lake, WAN5662AMccafferty John · East Jordan, MIN5662BHollibird Aviation LLC · Knightdale, NCN5662EFriendly Frogs LLC · Winona, MNN5663ETschirky Ted S · Pasco, WAN5664ASale Reported · Spirit Lake, IDSale reportedN5665CWilson Thomas S · Fallbrook, CAN5665JFarwest Aviation LLC · Billings, MTN5665RLimmer Rita G · Redding, CAN5666ARonshausen Steven A · Circleville, OHN5666B98x LLC · Caddo Mills, TXN5666EYakle Paul R · Lebanon, MON5666RSport Flying USA Inc · Ronkonkoma, NYN5667BMarmitt Management Inc · Moses Lake, WAN5667CClassic Aviation Inc · Pella, IAN5667EFolbre Frank S · Millsap, TXN5667KSmith John L · Renton, WAN5667RBrazos River Aviation Group LLC · Mineral Wells, TXN5668CMatthews Victor M · Comstock Park, MIN5668EGreene Daniel W · Yuma, AZN5668TShattuck Shaun R Jr · Coarsegold, CAN5669ABlanchette Charles · Payson, AZN5669CMorris Kenneth E · Poplar Grove, ILN5669JWeber David A · Bryan, TXN5669RBeasley Marty J · Statesboro, GAN5669TClemmons Gavin T · Hopkins, MNN566BGN566bg LLC · Leesburg, VAN566CPCivil Air Patrol · Maxwell Afb, ALN566DDeland Aviation LLC · Deland, FLN566EREmbry-Riddle Aeronautical University Inc · Prescott, AZN566GSPomeroy Cattle Ranch LLC · Kalispell, MTN566HCThomas Charles Stephen Trustee · Lakeway, TXN566JCMurphy Janel L · Lake Lure, NCN566JWRoss Stephen D · Greenfield, OHN566NDCoast Flight Training And Management Inc · San Diego, CAN566QButte Aviation Inc · Butte, MTN566RMBueter Eric · Wauseon, OHN566SPLlp Leasing Group LLC · Lewes, DEN5670R&R Aircraft LLC · Chugiak, AKN5670BHart Deric C · Anchorage, AKN5670JBank Of Utah Trustee · Salt Lake City, UTN5671AJarvis Peter S · Lebanon, CTN5671BVaughn William · Charlotte, NCN5671CBredin William B · Anchorage, AKN5672BToumala Scott R · Bemidji, MNN5672GHarrold Adam T · New Waterford, OHN5673CBuzbee Nancy C · Mineral Wells, TXN5673EFarwell William B · Benton, PAN5674AStearns Edwin Ben Jr · Chandler, AZ
Back to AD 79-10-14 R1