AD 75-09-13
Registered aircraft · 4,787
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:75-09-13')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13')
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:75-09-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:75-09-13') 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.
N509RSHalf Shell Aviation LLC · Highlands Ranch, CON50CBHughes Eugene F Jr · Butte, MTN50CTAyers Jeffrey D · Canandaigua, NYN50DDQualitair LLC Trustee · MichelstadtN50DLSand Castle Management LLC · Wichita, KSN50GBOviedo Juan M III · Oak Point, TXN50HGBethune David Scott · Stockton, CAN50MAGoodhue David H · Vancouver, WAN50RHPlane Fun Inc Tr Trustee · Snellville, GAN50SHVitatoe Industries Inc · Chillicothe, OHN5105YMcduff Douglas M · Cook, MNN5106CQuest Aviation Inc · Lake City, FLN5107CDalrymple Michael J · San Luis Obispo, CAN5107WRugger Investment Group LLC · Sheridan, WYN5109QRmcb LLC · Kalispell, MTN510NEAirswiss Inc · Wilmington, DEN510TFLang Eric O · Oklahoma City, OKN510WFFuel Center Plus Inc · Silver City, NMN5111JValiair Ltd Co Trustee · Casper, WYN5114QJ&A Air · Richfield, UTN511RLHatch Leasing Co LLC · Marble Canyon, AZN5122QPyxis LLC · Cheyenne, WYN51237Infanger James Robert · Salmon, IDN5124WBest Life Aviation LLC · Cedar Park, TXN5127QRegistered aircraftN512GTBarron Thomas Aviation Inc · Scottsdale, AZN512HPN512hp LLC · Dover, DEN512KZotec Partners LLC · Carmel, INN512SBN512sb LLC · Austin, TXN512SLSalmon Raymond A Trustee · Tavares, FLN512TWDelaware Aircraft Trust LLC Trustee · New Castle, DEN5130AAll Florida Aviation Inc · West Palm Beach, FLN5130YMerritt LLC · Leesburg, VAN5131QLeavitt Craig S · Spicewood, TXN5134CEzrydr LLC · Huntsville, ALN5134WPlane Fun Inc Tr Trustee · Snellville, GAN513DWright Aero Inc · Saint Cloud, MNN513SJWagner Distributing Co Inc · Auburn, CAN5140JTruk Err Inc · Wilmington, DEN5141QImagination Publications Inc DBA · Saratoga, WYN5144UAeronaut LLC · Saint George, UTN514HRSethi Inderdeep Singh · Tracy, CAN514LPInvader Aviation LLC · Tijeras, NMN514NCHyannis Air Service Inc · Hyannis, MAN5151JHalverson Mechanical Inc · Ogden, UTN5151QNotsa LLC · Morrison, CON5154AA&J Air Sales Inc · San Antonio, TXN5156QN5156q Inc · Elmhurst, ILFirst renewal noticeN5156YCaprock Spraying Inc · Vega, TXN5159ADavis Nicholas R · Madera, CA
Back to AD 75-09-13