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.
N516LPSun City Aviation LLC · Davie, FLN516MSSouth Bay Aviation Inc · Torrance, CAN516PCSpace Coast Aircraft Co · Merritt Island, FLN516PUAirplanes And Helicopters Of Oregon LLC · Sisters, ORN516RCCutter Robert W · Irmo, SCN516RVFoster Todd H · Long Beach, CAN516SBKnapp Nicholas R Trustee · Portland, ORN516SCThomason Scott D · Greer, SCN516SPOrlando Aeroclub Inc · Orlando, FLN516TDFisher Thomas A · Buckingham, FLN516TGNatchez Flight Training LLC · Natchez, MSN51700Brown County Flying Club · Aberdeen, SDN5170MWheeler David A · York, PAN5170PBosch Christopher J · Bloomington, MNN5170THardison Aviation LLC · Hampton, SCN5170XFitzpatrick Robert M · Fredericksburg, TXN5171FElliot Gary L · Aguila, AZN5171HPan Air Flying Club · Miami, FLN5171KBrewer Curtis E · Millington, TNN5171LCrum Clarence F · West Salem, OHN5171RSamuels Jay M · East Tawas, MIN5171TGowins Steven M · Eagle, AKN5171USummers Jeffrey L · Pekin, INN5171WPeters W Benny · Garden City, KSN51723Rhoads Timothy C · Logan, NMN5172BJames David R · Wayne, MIN5172HMsi Fuel Management Inc · Vacaville, CAN5172TJacksonville Aviation Group LLC · Jacksonville, FLN5172XO'Daniel Mike · Elkhorn, NEN5172ZTurner William J · Twentynine Palms, CAN51735Styer David B · Milton Freewater, ORN5173LDevries Pat DBA · Germansville, PAN5173PColorado Aviation Group LLC · Colorado Springs, CON5173SDamore Joseph · Ingleside, ILN5173TMorris Dennie R · North Fort Myers, FLN5173XInabnit Michael S · Colville, WAN5173ZSvenningse Joshua J · Menomonie, WIN51748Planenutz LLC · Deland, FLN5174AWells Lavar W · Hanksville, UTN5174BSky Associates Inc · Jupiter, FLN5174EBlue Sky Pilots Inc · Salem, ORN5174HFlying Finn Enterprises LLC · Wilmington, DEN5174LVentura Robert E · Ventura, CAN5174SKatzakian Trevor T · Lodi, CAN5174TMarnoch Kenneth S Trustee · Canyon Country, CAN5174ZSale Reported · Spearfish, SDSale reportedN51757Spencer John S · Indian, AKN51758Enstrom Instruction LLC · Newark, DEN5175DSlug Air LLC · White Salmon, WAN5175EWinston Jacob · Granbury, TX
Back to AD 90-04-06 R1