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.
N6735MJenks John W · Marlton, NJN6736AFogleman Brian L · Stonewall, LAN6736FN6736f LLC · Port Saint Lucie, FLN6736MDehaan Aviation LLC · Bethel, AKN6736RD Kevin Lester Md Inc · Fresno, CAN6737AEdmiston Dave L · Clifton, TXN6737RJpk LLC · Waterloo, NEN6738ABufford David T · Union Springs, ALFirst renewal noticeN6738EHaering Harold J Jr · Downers Grove, ILN6738FOakley Keith C · Montgomery, ALN6738GSpark Aero LLC · Christiansburg, VAN673ATCitizen Air LLC · Port Angeles, WAN673CBBurge Jerome C · Thousand Oaks, CAN673DKBh Aero LLC · Hanover, MNN673DWSunrise Aviation Inc · Ormond Beach, FLN673EREmbry Riddle Aeronautical University Inc · Prescott, AZN673JHAb Prop Plane II LLC · Metairie, LAN673MALewis University · Romeoville, ILN673SP673sp LLC · Blaine, MNN673XBusy Bee Ventures Inc · Cherokee, NCN6740AWillis John Y · Pine Mountain, GAN6740EDoughty Gregory · Wheaton, ILN6740FUwanawich Miller · Los Angeles, CAN6741EIntegrating Aviation & Ministry · Coldwater, MIN6741TCavanaugh Flight Museum · Denison, TXN6742ABouton Vern H · Fairbanks, AKN6743AChenier Mark S · Goldsboro, NCN6743EPop Ciprian S · Reno, NVN6743HCape Fear Aviation Maintenance LLC · Fayetteville, NCN6743RBas Part Sales LLC · Greeley, CON6744ALa Rue Carl A · Cambridge, OHN6744GRenfrow Denny M · Kelseyville, CAN6744SGoodrich Flying LLC · Corinne, UTN6744WSouthwest Flying Club · The Woodlands, TXN6745PPinnacle Aviation Services Inc · Encinitas, CAN6745RHurt Todd A · Springfield, ORN6746EKobberdahl Marcel A · Deerwood, MNN6746GKelsay Roger B · Hillsboro, ORN6746RSchwartz Daniel T · Meeker, CON6747AMatt Brit A · Sioux Falls, SDFirst renewal noticeN6747HAurora Skyhawks · Portland, ORN6748FStone Charles N · Chetopa, KSN6748HN6748h LLC · Palm Beach Gardens, FLN6749AOwens Wilbur · Rch Palos Vrd, CAN6749FWright Steven · Shelbyville, TNN6749RPmbarrett Aviation LLC · Tucson, AZN674CPCivil Air Patrol · Maxwell Afb, ALN674DWSunrise Aviation Inc · Ormond Beach, FLN674EREmbry-Riddle Aeronautical University Inc · Prescott, AZN674MPhillips Joseph H · Anchorage, AK
Back to AD 79-10-14 R1