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.
N84634Johnson Marty C · De Berry, TXN8463JMission Aircraft LLC · Friendswood, TXN8463LWings Over Texas Holdings LLC · Denton, TXN8463WLittleton Darrel · Atlanta, TXN84642Elder Russell W · Kirbyville, TXN84644Dixon Paul C · Gilbert, AZN84645In The Grey Aviation LLC · Seadrift, TXFirst renewal noticeN84647Falcons Aloft LLC · Friday Harbor, WAN8464DRegistered aircraftN8464JIshawooa Air LLC · Cody, WYN8464RBarbrie Nicholas J · Pittston, PAFirst renewal noticeN8464WWiedemann Shane L · Ridgecrest, CAN8464YTurner Terrance A · Anchorage, AKN84656Mitchell Larry Trustee · Kingsland, ARN84657Myler Mitchell · Bluffdale, UTN84659Laurel Highlands Aeronautical Academy · Latrobe, PAN8465BLalaguna Ricardo · Orlando, FLN8465CFlyzone LLC · Mount Laurel, NJN8465DDame Chris A · Harrisburg, ORN84662Caverns Consulting LLC · Purcellville, VAN8466BPaphos Airways LLC · Farmingdale, NYN8466CBaker Matthew T · Shipman, ILN8466EGoldstein Allan · Elk Grove Village, ILN8466HOsgood Richard E · Boscawen, NHN8466LWild Blue Yonder LLC · Lewes, DEN8466RCoffman Shane · Liberty, INN84678Elizabethtown Flying Service Inc · Elizabethtown, KYN8467BAthens Aero Club Inc · Athens, OHN8467DAlexander Sam · Fair Play, MON8467RHowe Phillip Brandon · Hendersonville, TNN84686Registered aircraftN84688Quad Cities Aero LLC · Bettendorf, IAN8468CIntravaia Anthony J · Mountain View, CAN8468DBliss James B · Anchorage, AKN8468EScotts Helicopter Services Inc · Le Sueur, MNN8468LMidstate Aviation 1 LLC · Owosso, MIN8468WTailwinds Inc · Clear Spring, MDN8468YStone D L · Arlington, TXN84695Pike Mark D · Victorville, CAN84699Skyknights Of Western Ky Inc · Calvert City, KYN8469DPeppel Tom · Big Lake, AKN8469HBolter Aviation Inc · Lewisville, TXN8469LZitko Philip R · Shelby, OHN8469TLally Thomas J · Manomet, MAN846AAAb Prop Plane I LLC · Metairie, LAN846DLRodgers William B · Dearing, GAN846EAkland Konrad R · Missoula, MTN846LLLindner James F · Williamsburg, MIN846SPSky Cag LLC · Hermosa Beach, CAN846TCTexas State Technical College · Waco, TX
Back to AD 90-04-06 R1