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.
N41811Farm Air Inc · Astoria, ILN41813Secrest Kenneth W · Griffin, GAN41816Privitt Bret J · Fort Worth, TXN41818Clinard Joshua G · San Luis Obispo, CAN41819Crop Jet Aviation LLC · Gooding, IDN4181HBarnett Keith T · Holmes, NYN4181MHayden Christopher J · Old Orchard Beach, MEN4181ZBraswell William J · Belzoni, MSN41820Wagner Patricia · West Milton, OHN41821Gilroy Joseph T · Escalon, CAN41822Kitchen Thomas M · Indiana, PAN41826Trull Stephen G · Golden Valley, MNN4182DBarnhart David H · San Antonio, TXN4182HAir Superiority Inc · Syracuse, NYN4182JBialecki Aviation Leasing LLC · Getzville, NYN4182LHorizon Dreams LLC · Homer, GAN4182MGreer Guy A · Wasilla, AKN4182TMelbourne Flight Training LLC · Melbourne, FLN4182YShouling & Philip Enterprise · Lancaster, CAN4182ZKing Air Inc · Naknek, AKN4183NEndeavour Flight Training Inc · Miami, FLN4183ZTirrell Troy L · Cordova, AKN4184HArrow Alan B · Magnolia, TXN4184JGorman Jeffrey M · Ellensburg, WAN4184TMullys Equipment Leasing LLC · Castle Pines, CON4184VUpper Jets Maintenance LLC · Miami, FLN4184YMoncrief Rick L · Melba, IDN4184ZCross L Ranch Inc · Cohagen, MTN41858Skybound Aviation LLC · Kernersville, NCN41859Morale Joseph D · Dallas, TXN4185WJames William S · Orange Park, FLN4185ZHill Leslie E · Patten, MEN41867Stevens Charles O · Columbus, MSN4186HMiller Paul D · Sterling, VAN4186ZSturgeon Ronald A · Anchorage, AKN4187JPeterson Erik J · Revillo, SDN4187YStohr Beuford G · Woden, IAN4187ZPickus Norman F · Fairbanks, AKN41880Brown Terry K · Eddyville, IAN41882Monroe Robert E · Navarre, FLN41888Lanyi Clifford M · Attleboro, MAN4188JLaib Aaron B · Emporia, KSN4188MLindholm Michael D · Anchorage, AKN4188PAero Club Valkaria LLC · Malabar, FLN4188TBird Acquisition LLC · Phoenix, AZN4188ZDanielson Debra · Skillman, NJN41896Hoffman Rick · Buckley, WAN41897Unlimited Upside LLC · Boggstown, INN4189BKruger Thomas H · Hoquiam, WAN4189HDouble D Aircraft LLC · Sergeant Bluff, IA
Back to AD 90-04-06 R1