AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N783NDVertol Systems Company Inc · Destin, FLN783RVAvexp1 LLC · Fayetteville, GAN783SCWeiblen Glenn P · Castroville, TXN783SHKmc Aircraft Leasing LLC · Spanish Fork, UTN783VVanstory Randy · New Braunfels, TXN783WWThomas Michael D · Centralia, WAN78408On The Fly Aero LLC · Ocean City, NJN7840DDavis Steven T · Colleyville, TXN7840FLederach David B · Bethlehem, PAN7840NBiby Steven R · Churchs Ferry, NDN7840VShedd John G · Hopewell, NJN7840WTomic Milos · Westminster, CON7840XShaw Christopher S · Porterville, CAFirst renewal noticeN7840YArno Philip A · Clarence Center, NYN7841HCross Thomas Ad · Yacolt, WAN7841VKohler Donald L W · Hernando, FLN7841WBasin Flyers LLC · Klamath Falls, ORN78424Acapulco Flying Club LLC · New Brighton, MNN78428Cypher Anne K · The Dalles, ORN78429Doughty Robert M · Earlville, ILN7842BLowe David M · Sacramento, KYN7842DCasler Robert A · Phelps, NYN7842GChildress Aviation LLC · Conway, ARN7842HMcgregor Daniel A · Denali Park, AKN7842NBoon Andrea Elizabeth · Bloomingdale, NYN7842PFall Stuart W · Holland, MIN7842SDoyle Terry W · Grapevine, TXN78436Vp Aviation LLC · Woodstock, NYN7843GFlybarely LLC · Manitowoc, WIN7843NA10 Aviation LLC · Peachtree City, GAN78440Boeing Employees Flying Association · Renton, WAN78441444.Com LLC · Wilmington, DEN78442Sullivan Darrell L · New Plymouth, IDN78444Hupe John F · Wamego, KSN78445Wings Over Texas Holdings LLC · Denton, TXN78447Larson Larry L Trustee · Molt, MTN78449Svendsen Gregory R · Anchorage, AKN7844GRedington James F · Hot Springs, VAN7844PTroy Watson Consulting Inc · Muleshoe, TXN7844VBanterra Bank · Marion, ILN7844WSaddy Rock · Henderson, NVN78450Gage Farms Inc · Stanberry, MON78453Sale Reported · None, OKSale reported, canceledN78454Powell Sherman B · Falkville, ALN78456Deoudes Demitrios N · Anchorage, AKN78458Heffley And Ruiz LLC · Waco, TXN78459Sutton George G · Richland Center, WIN7845DParr Richard · Pittsboro, NCN7845GSolorio Inc · Mission, TXN7845MGilbert David L · Madison, SD
Back to AD 81-18-04 R2