AD 90-04-06 R1
Registered aircraft · 68,377
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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.
N6751VManley 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, MSN6753VDegraffenreid 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, OKN6757Mattheis 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, MDN6758DCaruso Dennis · Saint Marys, PAN6758HGorge 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, CAN675DDRice Allen J · Steinhatchee, FLFirst renewal noticeN675GMMeuer Gary · Tullahoma, TNN675JBRegistered aircraftN675JLLebechuck Kelly S · Murfreesboro, TN
Back to AD 90-04-06 R1