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.
N629WSPrecision Avionics Specialists · Griffin, GAN62ACAllen Chorman & Son Inc · Milton, DEN62AWDirty Side Down Aviation LLC · Georgetown, TXN62CGJain Ashish K · Hamilton, GAN62ECSharp Aviation LLC · Pauls Valley, OKN62GKAugusta Flying Club Inc · Martinez, GAN62JLCronin John · Port Orange, FLN62KKinyoun Robert C Jr · Bluff Point, NYN62KJStephani Timothy M · White Lake, WIN62LGScout Aviation LLC · Alden, IAN62LULouisville Aircraft Leasing LLC · Louisville, KYN62NAAdventure Aviation West LLC · Kalispell, MTN62PBAlabama Fly Boys LLC · Cropwell, ALN62SGozashti Farid H · Abilene, TXN62SMBell Charles S · Fort Payne, ALN62WPCarver Joseph · Bryson City, NCN63000Jet Boy LLC · Henderson, NVN63001Rbv Aviation And Cattle LLC · Kalispell, MTN63002Nolt Shannon E · East Earl, PAN63003Newell Rory H · Warner Springs, CAN63006Registration Pending · Snohomish, WARegistration pendingN63008Wheaton Eric J · Gig Harbor, WAN6300AByrne Theodore · Cannon Falls, MNN6300KCash Richard W · Bossier City, LAN63014Taylor Daniel S · The Woodlands, TXN63017Adams Aviation Services Inc Trustee · Wilmington, DEN63019Althaver David B · Kearny, NJN6301AJohnson James A · Fairbanks, AKN6301DR&R Aero Services LLC · Eden Prairie, MNN6301EJc Air Academy Inc · Stockton, CAN6301SAbercrombie Michael J · Eureka, CAN6302FForrest Steven L · Wrangell, AKN63033Baumer Luke R · Pittsboro, INN63036Registered aircraftN6303BUpper Valley Aero LLC · Hanover, NHN6303DKilbourn Stuart L · Hughesville, PAN6303FCommercial Leasing Unlimited LLC · Mesa, AZN63040Bullington Michael D · Spring Hill, TNN63042Ting Chih-Wei · Tracy, CAN63046Lindholm Michael D · Anchorage, AKN63047Ggf Inc · Jacksonville, ARN6304KMeadows Michael M · Cypress, TXN6304SCowey Kevin M · Pittsburgh, PAN6304UHutt Aviation Inc · Minden, NVN63051Moss Ronald J · Hamer, IDN63053Claeys John T · Blue Grass, IAN63057Guerra Enmanuel M · Weirsdale, FLN6305AMissouri Aviation Inc · Leeton, MON6305BLeggett Bryce · Eola, TXN6305FGianquinto Joseph J Trustee · Bakersfield, CA
Back to AD 79-10-14 R1