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.
N597SPViolet Sparkle Pearl LLC · Hanover, NHN597TTTerrell David R · Smithville, TNN597TXCareer Track 2 LLC · Wilmington, DEN5980AFinstad Brandon C · South Weber, UTN5980EHarris Kenneth L · Greeley, CON5980GBall Albert N · Chugiak, AKN5980RPetes LLC · Pompton Plains, NJN5981ENelson David F · Onalaska, WAN5981RKenney Anthony G · Oviedo, FLN5981TLowe David · Sacramento, KYN5982EAblaihan Inc · Angels Camp, CAN5982FCharles James Brown · Littlefield, TXN5982TLifto Thomas W · Barronett, WIN5983BNck Consulting LLC · Scottsdale, AZN5983ESweet R Kent Trustee · Reno, NVN5983JIlarraza Gilberto C · Sabana Hoyos, PRN5983MPhilipp Michael W · Thief River Falls, MNN5984Eberle Larry L · Humble, TXN5984FFct Aviation LLC · Portales, NMN5984GClifton Raymond L · Pleasanton, TXN5984JZogleman Enterprises Inc · Viola, KSN5985ARimes Aviation LLC · Worthngtn Spg, FLN5985EAlderman Melvin R · Jacksonville, FLN5985GStanton Aviation Lc · Saint George, UTN5985JRuby Crest LLC · Girdwood, AKN5986FBingham Darold R · Idaho Falls, IDN5987ALong Randy M · Dewy Rose, GAN5987GSchwend Brian · Forsyth, MTN5987JBoerne Flight Options LLC · Boerne, TXN5988AHiggins Jeffery D · Minden, NVN5988BLarsen Christopher S · Pleasanton, CAN5988TInvestopia Online LLC · Houston, TXN5989ABrokaw Terry L · Three Rivers, MIN5989ESchiller Gregory L · Pittsburg, NHN5989TKnudtson Bruce A · Sioux Falls, SDN598ABBrynelsen Charles R · North Oaks, MNN598MCTeichroeb Peter · Seminole, TXN598SPFb Aviation LLC · Minot, MEN5990EManeuvering Speed Inc · Wilmington, DEN5991EWilliford Travis C · Sandersville, GAN5991JSchutes John T Jr · Port St Joe, FLN5991TDelima Joseph D · Livermore, CAN5992GPerry Aaron O · Piqua, OHN5992JLinback Ken R · Niles, MIN5993ETss Flying Club Inc · Bethesda, MDN5993GSchoenrock Timothy · Stillman Valley, ILN5994EMccallister Shawn D · Hendersonville, NCN5994TBundgard Peter A · Natchez, MSN5995AOanes Kenneth W · Merrillan, WIN5995BWilson Robert E III · Urbanna, VA
Back to AD 79-10-14 R1