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.
N6751JJones James L · White Hall, ARN6751NParr Matthew R · Wellsville, PAN6751PGette Jason D · Kindred, NDN6751VManley William T Jr · Lakeside, TXN67527H & H Aviation Enterprises LLC · Fairfield, OHN6752JHutchins James R · Columbia, SCN6752ULucarelli Michael · Surprise, AZN6752ZVector USA LLC · Olive Branch, MSN67535Afana Lawrence L · Laughlin, NVN6753BThorpe Brandon · Bremerton, WAN6753JSpieth John W · Ann Arbor, MIN6753NHarmon Benjamin P · Olive Branch, MSN6753PScanlon Shawn M · Evans, GAN6753VDegraffenreid Donald R · Fort Mohave, AZN67541Lane Community College · Eugene, ORN67542Haag Neil E · Elgin, SCN67549Pea-Wayman Flight LLC · Daytona Beach, FLN6754NCasady David E · Harriman, TNN6754VTharp Kenneth Lynn · Apple Valley, CAN6754WBell Christopher K · Reynoldsburg, OHN67557Sunstate Aviation Inc · Kissimmee, FLN6755BTwotards Aviation LLC · Moses Lake, WAN6755JBon Investment Holdings LLC · Zephyrhills, FLN6755PHensler Carl P · Watsonville, CAN6755WAeroqualite Maintenance · Cumberland, WIN67563Canarr Nellie N E · Anchorage, AKN67567Pinger Kevin R · Palo Alto, CAN6756BNortheast State Community College · Blountville, TNN6756JAmv Aviation LLC · Miami, FLN6756UBergland John E · Santa Monica, CAN6756VFelicione Frank S Jr · Idaho Falls, IDFirst renewal noticeN6756WTrollinger Lari D · Wanette, OKN6756ZKoenig Donald J · Las Animas, CON6757Mattheis Mark E · Fort Wayne, INN67573Fixed Wing Holding Co Inc · Pembroke Pines, FLN6757BStuart Lee L · Smithville, ARN6757NCoody John A · Idaho Falls, IDN6757UScherger Mark A · Herndon, VAN6757XCall One Inc · Clarinda, IAN67582Jackson William Gary · Clinton, MDN6758HGorge Winds Aviation Inc · Fairview, ORN6758JBroach William S · Forest Hill, MDN6758NZwerko Kevin C · South Plainfield, NJN6758PRoss David T · El Dorado Hills, CAN6758UN6758u LLC · Linden, MIN67591Owen David A · Saint George, UTN6759BDean Richard L · Ridgeland, SCN6759UHodgson Michael D · Saint Francis, WIN6759WMakeev Alexandre · Concord, CAN675CPCalifornia Polytechnic State University · San Luis Obispo, CA
Back to AD 81-18-04 R2