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.
N4759XBaginsky D D · Salesville, OHN475EREmbry-Riddle Aeronautical University · Daytona Beach, FLN475LN475l LLC · Boise, IDN4760CJaars Inc · Waxhaw, NCN4760EYoung John L · Glorieta, NMN4761CForbis Aviation LLC · Calera, OKN4761DNordstrom Anne D Trustee · Walpole, NHN4761EDorsheimer Ryan J · Camp Hill, PAN4761QMichaelson Lawrence · Big Lake, AKN4762BAllen Kenneth W · Anchorage, AKN4762EFly185 LLC · Estes Park, CON4762XSpatiumtech LLC · Madison, ALN4763DRandolph Terrence · Bowie, MDN4763NBathum Dale · Ketchum, IDN4763UCopper River Airmotive LLC · Copper Center, AKN4764BPratt Sean · Hampton, NHN4764DQuadrelec Engineering Corp · Tulsa, OKN4764NWhite Robert H · Eagar, AZN4764QShapiro David · Homer, AKN4764URegistered aircraftN47657Dallam Pat M · Cool, CAN4765QDigger Dougs Crop Dusting Services Inc · Salem, WIN4766DHutchison Frank J · Tucson, AZN4766EWillard Raymond C · Wasilla, AKN4766UMoore Murray H · Twain Harte, CAN4767DFulton Daniel M · Blacksburg, SCN4767NDavid Bell Farms Inc. Po Box 160 · Beaverton, ORN4767UDeckload Aviation LLC · Kodiak, AKN4768BEversole Eric L · Kent, WAN4768DBoyd Amy L · Kila, MTN4768EEagle Aviation Inc · Tucson, AZN4768FZankiz Jose Carlos · Naples, FLN4768NTreadwell Dennis A · El Cajon, CAN4769BNesbett David A Trustee · Anchorage, AKN4769NTurner Luke · Mineral Wells, TXN4769XAnderson Aviation LLC · Erie, PAN476CACivil Air Patrol · Maxwell Afb, ALN476CMUniversity Of Central Missouri · Warrensburg, MON476DTTallarita Domenic A · Palm Springs, CAN476DWSkylane Capital Group LLC · Seattle, WAN476EREmbry-Riddle Aeronautical University · Daytona Beach, FLN476KETrexel Paul C · Willits, CAN476LSHoffman Anthony J Trustee · Hillsboro, ORN476MSBrooks Duane T Trustee · Mount Shasta, CAN476SPChristiansen Aviation LLC · Wilmington, DEN4770DNapier Michael D · Russell, KYN4771ULoomis Rick A · Prescott, AZN4772EDrost Larry L · Charlevoix, MIN4772QHodgson John P · Atlanta, GAN4772RKimball Michael G · Placerville, CO
Back to AD 79-10-14 R1