AD 2012-10-13
Registered aircraft · 13,306
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:2012-10-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:2012-10-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:2012-10-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:2012-10-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.
N5084VAerospace Trust Management LLC Trustee · Wilmington, DEN5089C5089c LLC · Fairhope, ALN508BMGreen Team Motors LLC · Olathe, KSN508DBCatalano George A · Scottsdale, AZN508DFStephens James Anthony · Baton Rouge, LAN508DKTravel Express Aviation LLC · West Chicago, ILN508JBJuliet Bravo LLC · Olathe, KSN508JDSterling Aviation Group LLC · Colorado Springs, CON508KMHigh Sierra Holdings LLC · Wellesley, MAN508LCThomas Kevin · Gardendale, ALN508RASouthern Aircraft Consultancy Inc Trustee · Casper, WYN508SBSms Aviation LLC · Odessa, TXN508TCFisher Travis L · Odessa, TXN508VBFlight Quest Aviation LLC · Camden, DEN508WHBas Part Sales LLC · Greeley, CON508WKSnow Shore Aviation LLC · Harwich, MAN50901United Indian Missions Inc DBA · Tucson, AZN5091CMartin Steven J · Phoenix, AZN5096RProvestment International LLC · West Melbourne, FLN5098QM&L Engine LLC · Schriever, LAN509CDTfs Limited LLC · Scarborough, MEN509CETitle Associates LLC · Hurricane, UTN509CMKuppinger Aviation Services LLC · Kissimmee, FLN509CPWalsh Jacob R · Tucson, AZN509MCCicerchi Michael P · Denver, CON509PTailwindsbikelyft LLC · Hannibal, MON509RRAlten Flight LLC · Northbrook, ILN509RSHalf Shell Aviation LLC · Highlands Ranch, CON509SRWb Holdings LLC · Royal City, WAN50BVStrickland H Len Jr · Fairhope, ALN50CBHughes Eugene F Jr · Butte, MTN50CTAyers Jeffrey D · Canandaigua, NYN50DDQualitair LLC Trustee · MichelstadtN50DNNlw Inc · Indianapolis, INN50ECPremier Wireless LLC · Kalispell, MTN50FTN50ft LLC · Boca Raton, FLN50GBOviedo Juan M III · Oak Point, TXN50HGBethune David Scott · Stockton, CAN50MAGoodhue David H · Vancouver, WAN50RHPlane Fun Inc Tr Trustee · Snellville, GAN50SHVitatoe Industries Inc · Chillicothe, OHN50WTBase Aviation LLC · Grand Junction, CON50XLQualitair LLC Trustee · MichelstadtN5105YMcduff Douglas M · Cook, MNN5106CQuest Aviation Inc · Lake City, FLN5107CDalrymple Michael J · San Luis Obispo, CAN5107WRugger Investment Group LLC · Sheridan, WYN5109QRmcb LLC · Kalispell, MTN510CDMcgraw Jon W · Sitka, AKN510CKCampbellklein Aviation LLC · Whitefish, MT
Back to AD 2012-10-13