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.
N54322Myers Robert E · Sperry, OKN54324T2xb LLC · Valdosta, GAN5432BDixon Charles W · Brookhaven, MSN5432CBarbee James E · Mason Neck, VAN5432EMilwaukee Aero LLC · Milwaukee, WIN5432HArmstrong Aviation Services LLC · Freeport, PAN5432RMishmash Christopher L · Valdez, AKN5432VMj Aerial LLC · Wasilla, AKN5433BBlue Moon Aviation LLC · Grangeville, IDN5433EAty Aviation Inc · Watertown, SDN5433RJones Kenneth Jr · Lufkin, TXN5433XMk Air LLC · Lewistown, MTN54346Aviation Trust Company LLC Trustee · Oklahoma City, OKN5434ASteele Group Insurance Agency Inc · Eugene, ORN5434DSierra Lima Aviation LLC · Riverton, UTN5434EMiller Shane D · Cherokee, OKN5434RFlorida Keys Flight Academy LLC · Marathon, FLN5434SAnderas Per R · Green Bay, WIN5434VInhouse Graphics Inc · Brookshire, TXN54355Elizabeth City State University · Elizabeth City, NCN54357Rick Aviation Inc · Newport News, VAN5435BMacomber Gregory S · Kalamazoo, MIN5435EWings Over Texas Holdings LLC · Denton, TXN5435HWindham Brealon A · Kingsville, TXN5435J22december LLC · Bartlett, ILN5435QHutchins Kent F · Carbon, INN54360A S Flight Academy LLC · Lantana, FLN5436AJls Investments Inc · Lafayette, LAN5436EKitsap Aviation Squadron Inc · Southworth, WAN5436HTrue Course Air LLC · Rich Hill, MON5436QAdler Richard A · Leland, NCN5436TStrachn Adam · Lenoir City, TNN5436UNewsom William Joel III · Roswell, GAN54371Clare Air Services LLC · Saint Johns, MIN5437CHand Loraine A · Tahlequah, OKN5437HBuena Vista Flying Club Inc · Richland Center, WIN5437JMiloud Chadd K · Fort Worth, TXN5437QMetro Technology Aviation Campus · Oklahoma City, OKN5437RSchafer Brian L · Carleton, MIN54381Paradise South Ventures LLC · Marco Island, FLN5438BMoore Ryan T · Nampa, IDN5438ECsp Aviation LLC · Stuart, FLN5438TFritz James A · Pierce, NEN5439CLopez Hugo E · Mcallen, TXFirst renewal noticeN5439HMeyer Aviation Group LLC · Grand Island, NEN5439KEastern Kentucky University · Richmond, KYN5439RIndian Hills Community College · Ottumwa, IAN5439TSlone James E · Grundy, VAN543ARHoffman Elliott R · Bethel, AKN543DFRichardson Daniel D · Caldwell, ID
Back to AD 79-10-14 R1